THE ACCURATERELOADING.COM TECHONOLOGY FORUM

5MB IBM Hard Drive in 1956


Moderators: Saeed
Go
New
Find
Notify
Tools
Reply
  
MS Excel - vista glitch pissing me off
 Login/Join
 
one of us
posted
I am working with an Excel template, prepared with Excel 2007 but saved as a 97-2003 file. I have many formulas throughout the book. Sometimes when I open it and delete cell contents, the formulas do not recalculate - I have to go into the formula, click on it, click enter and then it will recalculate. With 100+ formulas this fix is not an option. Has anyone experienced this with Excel 2007? Very frustrating.
 
Posts: 62 | Location: Temple Terrace, Florida, USA | Registered: 23 January 2009Reply With Quote
Moderator
posted Hide Post
Check the Microsoft site to see if an "Excel template, prepared with Excel 2007 but saved as a 97-2003 file" is supported.

There may be a knowledge base article or forum discussion about this.

George


 
Posts: 14623 | Location: San Antonio, TX | Registered: 22 May 2001Reply With Quote
one of us
posted Hide Post
I found a fix...there is an "Excel options" menu and a checkbox for "Formulas > Auto-recalculate".
 
Posts: 62 | Location: Temple Terrace, Florida, USA | Registered: 23 January 2009Reply With Quote
  Powered by Social Strata  
 


Copyright December 1997-2021 Accuratereloading.com


Visit our on-line store for AR Memorabilia

 

image linking to 100 Top Hunting Sites