Calculate message
My file was crashed last Friday, after recovery, the file has repaired next
to file name when I open it. Also it starts calculating file every time I open it. I copied the tabs I need to use to a new file. It's still doing calculating every time when I open it. These tabs I copied to the new file, only have add functions in few rows, it's a small file, but it takes long time to calculating this small file everytime when I open it. |
Calculate message
Hi Holly,
You might check with Ctr+End to check your lastcell position. http://www.mvps.org/dmcritchie/excel/lastcell.htm If that looks okay, meaning it is near you data then perhaps you have added User Defined Functions that have volatile added so that they are calculated everytime a calculation is asked for. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Holly" wrote in message ... My file was crashed last Friday, after recovery, the file has repaired next to file name when I open it. Also it starts calculating file every time I open it. I copied the tabs I need to use to a new file. It's still doing calculating every time when I open it. These tabs I copied to the new file, only have add functions in few rows, it's a small file, but it takes long time to calculating this small file everytime when I open it. |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com