Prevent recalculation of formula when opening older ver

[gpta]

I want to be able to prevent Excel from recalculating formulas when opening a workbook with a newer version. This is not a one time need or on a case-by-case basis. The following KB article comes close but is for a single document - I need it blindly for all documents that are opened:

http://support.microsoft.com/kb/289111


Here is the reason I need this. I have a process that opens and auto prints many Excel files (from email attachments). A lot of them are from newer versions, but some are from older versions. When older versions open and then print, it leaves the Save prompt because formulas were 'recalculated'. This kills the process because it never closes to older version file. Does anyone have any ideas that could help? Thanks for looking.

 

[Andrew Poulsom]

The Calculation property is inherited, so the solution in the KB article will apply to all workbooks that are subsequently opened in the same instance of Excel.

What are you using for your automation process?

 

[SamBo1234]

Hello,

Im not an expert, but if this is done through VBA, post what you have already so that people can maybe modify the existing code and maybe help improve the process.

 

[gpta]

It is an add on to MS Outlook that will autoprint email attachments - in this case, Excel files. The product is Ornic InboxRules.

Whenever it comes across an excel file, it opens and autoprints it, but when trying to close it, it gets hung up with the Save dialog. Subsequent excel attachments will not open to be printed.

When I make the KB suggestion, it will not prompt me again for that specific file, but it will prompt me for others which is not helpful. Am I wrong or missing something?

Thanks.

 

[Andrew Poulsom]

I expect the Add-In is starting a new instance of Excel for each attachment. If that's the case I don't know a solution.

 

[gpta]

Yes, I believe it is. InboxRules seems to simply mimic what right-clicking the excel file and selecting Print does. It opens the file, sends it to the default printer, and then closes it. Any other questions/suggestions?

Thanks.