Disabling formula recalculation when opening or closing workbooks

J

Joe

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Excel 2007 formula recalculation 1
Importing data from .xlsx files 4
Look Up Formula With Veried Search Range 2
Word & Excel crash when closing (Win7Pro-64, Office2003) 0
Large Excel 2008 .xlsx file behaviour with Vista 3
Error when copying from spreadsheets in Office 2007 1
Can information be transferred between workbooks? 1

Top