How to prevent excel200 file to recalculate on startup in 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel file which was created on a bloomberg machine and contains
dde data,with office 2000 it would ask if links need to be updated and if you
say no so you could have the values preserved but when I try to open the file
in 2003, the linked data will become invalid regardless of my answer.
How could I simulate office 2000 behaviour in such case?
Thank you
 
Before you open the Bloomberg spreadsheet. open a new blank worksheet and set
the application to manual using calculation Tools-->OPtions-->Calculation.
Then open the bloomberg sheet - the numbers should stay static.
 
try this:

Open the registry editor and navigate to the key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options.
Now create a new DWORD item named: FullCalcOnLoadOldFile
Leave its value at the default of 0.
Close the registry editor and then test the issue.

Note : ask someone for help if you are not comfortable with the registry.
 
Hi,
Thank you for answer but I know these fixes and although it does answer part
of the issue but not fully.
Due to
1.Fullcalconloadoldfile reg doesnt always work - this is a fact and let me
explain why.
The problem is in the difference between recalculation in excel 2000 and
excel 2003
for example if I open the same file in office 2000 and say do not update
links,recalculation will stay automatic and the user will be able to utilise
other automatic function while keeping the data static.
In 2003 in order to open the file I have to turn it to manual recalculation
but this also breaks other automatic recalculation functionality such as
automatic formulas on multiple cells e.t.c... and if a user tries to set it
to automatic it will erase the linked values - rendering the file unusable.

Please let me know if I explain myself clearly - I can bring a better example.

Thank you
 
Back
Top