LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2007 formula recalculation

Hi there,

I have a web app in which users are able to add/view attached document of
various types, including Excel docs. We are upgrading to Office 2007, and so
users will soon have Excel 2007 on their machines. The problem we're facing
is that, when you open an Excel attachment in the app, where the Excel file
contains formulas, and then suqsequently try to close it, a message pops up
asking:
"Do you want to save changes to 'get_document.asp'? MS Office Excel
recalculates formulas when opening files last saved by an earlier version of
Excel."

You are then given the option to click Yes/No/Cancel.

How can I avoid this prompt popping up? I have tried clicking Yes, which
causes the file to be saved to the server, and have tried saving it as both
..xls and .xlsx format, but the message still appears whenever you open and
then close the attached file.

Any suggestions?
 
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
Disabling formula recalculation when opening or closing workbooks Joe Excel Discussion (Misc queries) 3 August 5th 08 09:24 PM
Formula Recalculation Error uknow message board Excel Worksheet Functions 2 September 21st 06 05:33 PM
Recalculation of Formula. Big Rick Excel Discussion (Misc queries) 5 September 8th 05 04:09 PM
Excel recalculation R Ormerod Excel Discussion (Misc queries) 3 May 4th 05 01:56 PM
Formula Recalculation after using AutoFilter DD in Virginia Excel Worksheet Functions 4 November 8th 04 01:41 AM


All times are GMT +1. The time now is 04:28 AM.

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

About Us

"It's about Microsoft Excel"