Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message box if cell is greater than less than 0 [Zero] | Excel Discussion (Misc queries) | |||
calculate message in status bar | Excel Discussion (Misc queries) | |||
Urgent- Help ! (Message 'Calculate' Appears) | Excel Discussion (Misc queries) | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) |