Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel 2007 cells not refreshing


(!)

marygrl2327's Avatar
marygrl2327 marygrl2327 is offline
Computer Specs
Junior Member with 2 posts.
THREAD STARTER
 
Join Date: Oct 2007
Experience: Advanced
05-Oct-2007, 09:26 AM #1
Excel 2007 cells not refreshing
I am having problems with Excel 2007 cells not refreshing. When I am updating a spreadsheet, the cell that has the formula will not refresh. I have to click on the cell and hit tab each time for the updated calculation. The same problem occurs when I am using the autofill function. Please help. Thanks!

**Update - I figured out how to correct the autofill error, but I still need to know why my cells containing formulas will not refresh when I update my spreadsheets. Thanks!**

Last edited by marygrl2327; 05-Oct-2007 at 11:09 AM..
cherry pie's Avatar
cherry pie cherry pie is offline
Computer Specs
Senior Member with 345 posts.
 
Join Date: Jun 2007
Location: Yemen
Experience: Advanced
05-Oct-2007, 11:23 AM #2
Click the (Office Button) In excel and choose (Excel options). Under the (formulas) tab there is an option for (workbook) calculation, make sure (automatic) is chosen.
__________________
Happy New Year

No more santa hats...



marygrl2327's Avatar
marygrl2327 marygrl2327 is offline
Computer Specs
Junior Member with 2 posts.
THREAD STARTER
 
Join Date: Oct 2007
Experience: Advanced
05-Oct-2007, 11:25 AM #3
Thanks! That fixed it
cherry pie's Avatar
cherry pie cherry pie is offline
Computer Specs
Senior Member with 345 posts.
 
Join Date: Jun 2007
Location: Yemen
Experience: Advanced
05-Oct-2007, 11:53 AM #4
Great... glad I could help
__________________
Happy New Year

No more santa hats...



jimr381's Avatar
jimr381 jimr381 is offline
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
05-Oct-2007, 12:10 PM #5
Could you please mark the post as solved via the "thread tools" drop-down list marygrl?
__________________
"Take what you learn and make a difference with it."
___________________________________________
"Oh, goody!"
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Forum Jump

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑