View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Opening Workbook resets calculation to automatic from manual etc

This is a setting that excel picks up from the first workbook opened in that
session.

So if you open excel and with book1 active, change calculation to manual (just
to make sure), then open your real workbook, it should open with calculation set
for manual.



Bill Shepherd wrote:

When I open an Excel workbook the option calculation 'manual' (my standard
setting) resets to 'automatic'. Subsequently the processing in the workbook
slows down progressively until it becomes hopelessly slow. In particular line
inserts/deletions are notably slow. I have uninstalled Excel (Excel 2003) and
reinstalled it and updated at the office update website; this makes no
difference to the problem.
Any ideas?
In despair.
Bill Shepherd


--

Dave Peterson