U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Old 06-21-2011, 08:52 AM
Location: Indiana
1 posts, read 1,041 times
Reputation: 10


Before I go through all the trouble to have IT reload Excel. Has anyone had the problem of the functions in Excel to quit working? Example: I have a spreadsheet that tracks deposits on a daily basis. I have always been able to just copy from the previous day all the formulas. I can no longer to this. It will also not automatically update when I have it set to sum a group of cells.

Your experiences are greatly appreciated.
Reply With Quote Quick reply to this message

Old 06-21-2011, 12:09 PM
Location: In a happy place
3,784 posts, read 7,044,227 times
Reputation: 7473
I have found this site to be very helpful.

Excel Help Forum
Reply With Quote Quick reply to this message
Old 06-22-2011, 01:26 PM
14,781 posts, read 36,588,956 times
Reputation: 14404
Go to "Tools" and click on "Options". It will open up a multi-tabbed menu. One of the tabs is marked "Calculation". On it you will see several options. Make sure the "Automatic" option is selected. You can also force it to do a "Calc Now" (or hit F9) that will rerun all the formulas in the workbook.

Occasionally for some strange reason I have had workbooks switch from automatic to manual and the formulas stop working. Usually in workbooks I do a lot of copying and pasting in.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.

Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads
Follow City-Data.com founder on our Forum or

All times are GMT -6.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top