LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Disabling formula recalculation when opening or closing workbooks

Does anyone know how to disable formula recalculation for all
spreadsheets, regardless of whether or not they were originally saved with
formulas, or previous versions of Excel?
I'm running Excel 2007 and have to open these xls or xlsx files to be
printed into our imaging system all day long (this is actually an automated
process). Because of the files being opened to be printed, the recalculation
of formulas within the file, or if the file is from an earlier version of
Excel, this causes the "save changes" window to appear. Is there anything
like and Excel reader or view that I could use in lieu of full blown Excel
just for the simple purpose of opening the file to print it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow Opening & Odd Closing ohsix New Users to Excel 1 May 20th 07 05:28 PM
Closing a workbook upon opening another Dave New Users to Excel 3 January 3rd 07 09:57 PM
Error while opening/Closing excel Hari Excel Discussion (Misc queries) 0 November 17th 06 06:55 AM
closing multi workbooks have_a_cup Excel Discussion (Misc queries) 2 June 28th 06 11:31 PM
Event on opening/closing groupings in VBA Dirk Flakowski Excel Discussion (Misc queries) 3 November 29th 05 03:52 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"