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 not calculating formulas?


(!)

eddyfrogs's Avatar
eddyfrogs eddyfrogs is offline
Junior Member with 29 posts.
THREAD STARTER
 
Join Date: Sep 2004
Experience: Intermediate
06-Oct-2005, 12:17 PM #1
Excel not calculating formulas?
Hello. I am using Excel 97 here at the office. I have numerous spreadsheets that have formulas in them. About a week ago, the spreadsheets quit automatically calculating the formulas. Say the formula is to calculate the sum of a column of numbers. I change on of the numbers in the column and the formula does not automatically update until I save the file.

Also, I copy a formula a lot and paste it to cells along a row in the spreadsheet. Now I get a message that says "cannot empty the clipboard". It still lets me complete the paste function but only after hitting the OK button on the error message twice. Rather annoying since I do this all day long.

I've searched Excel's stupid help feature everywhere and cannot find an answer. I, also, searched Microsoft's tech support section and no help there either. Please help!!!!!!
maxflia10's Avatar
maxflia10 maxflia10 is offline
Member with 331 posts.
 
Join Date: Feb 2003
06-Oct-2005, 12:50 PM #2
Check to see if the calculation mode is set to automatic by going to Tools/Options/Calculation tab and tick automatic.
eddyfrogs's Avatar
eddyfrogs eddyfrogs is offline
Junior Member with 29 posts.
THREAD STARTER
 
Join Date: Sep 2004
Experience: Intermediate
06-Oct-2005, 05:14 PM #3
Thanks it worked. I wonder how it got changed. Oh well, at least it is fixed.
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

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


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

Content Relevant URLs by vBSEO 3.3.2