Microsoft Excel Question:
Download Questions PDF

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

Answer:

This happens all of the time to MrExcel. I downloaded a little macro from Microsoft which helps you delete these links. Microsoft has now upgraded the macro to a full blown add-i

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
I use a large spreadsheet on a daily basis with 31 worksheets (one for each day of the month). Each worksheet is huge.I would like to insert another sheet in the workbook and insert a button to copy another worksheet to the end of the workbook and then rename the sheet to the correspondingday of the month?Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?