By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate files that were last saved in an earlier version of Excel. This ensures that any improvements made to the Excel calculation engine are applied to all formulas in the workbook.
To prevent Excel 2003 or Excel 2002 from automatically recalculating workbooks saved in earlier versions, follow these steps: 1. On the *Tools* menu, click *Options*. *NOTE*: The *Options* command is only available when a workbook is open. If it is not available, click *New* on the *File* menu, and then click *Blank Workbook* in the *New Workbook* task pane. 2. Click the *Calculation* tab. Under *Calculation*, click *Manual*. Click to clear the*Recalculate before save* check box. 3. Click *OK*. Regards, Andy On Sat, Aug 7, 2010 at 5:52 PM, Aindril De <aind...@gmail.com> wrote: > Hi Rahul, > > Which version of Excel are you using? > > Regards > Andy > > > On Sat, Aug 7, 2010 at 5:08 PM, rahul <axyin.ra...@hotmail.com> wrote: > >> When you open a workbook and then close it with out making any >> changes, you are prompted as follows: >> Do you want to save the changes to Filename.xls? >> >> Microsoft Excel recalculates formulas when opening files last saved by >> an earlier version of Excel. >> >> How to get rid of this problem >> >> File is uploaded on the below link >> >> http://www.sendspace.com/file/ztjm60 >> >> Can any one please help me out. >> >> >> Regards >> Rahul >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
