Search results

Hi!Fred, By Rows with no data, do you mean completely blank rows or rows with formulas but no data input in them to get results...? I normally copy paste my formula rows upto certain row nos like 999 or 3000,5000, etc.not more than 9999 anyway.But all my formulas are written for max upto 9999...

Hi! Madhavi, Adding to Hui's comment.. The Personal.xls file is located in the following, Program Files/Microsoft Office/Office11/XLSTART It is supposed to auto start whenever we open excel on the PC ( sometimes it doesnt-then you may have to create a shortcut to this file on your desktop...

Why do file sizes grow anyway, when the workbooks are shared? Does anyone know? Does Tracking Change History option have anything to do with it? Is there a proper way of using the Advanced option in shared workbook?

25-30MB is the size, only when it is fresh, after some staff has worked on it all day, the file size grows to nearly 90-100MB!To bring it back to size, I remove the sharing and put it back on. Changing over to latest versions of Excel, the problem is that our staff is not very computer savvy (...

Hi!Hui, Have carried out ur instructions and repaired the file,will let you know the result tomorrow when the file is used throughout the day, thanks a million, i sure hope this fixes it! by the way it is brilliant how you find these tiny nuggets of precious info hidden away!! first time i...

file size is 25-30mb

AM USING EXCEL 2003 will try out open and repair immediately and revert thanks!

Hi! we are using Windows XP and I do not see Open and Repair anywhere!? Also do not get the option in Save As for *.xlsb type file format Another thing is that this saving activity has to be done on the live document many times in a day, so it is not a one off event, whether above procedure...

Dear Hui, not sure i understood, can u pls elaborate.?

I have an Excel 2003 application package (all developed by me) which is inclusive of large files with links and formulae. I have built all sorts of small tools to assist me in my business and needless to say our entire operations run on Excel ( and quite well i must say!)! But one large file...