Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel not updating as I type
Name: helenjane Date: March 23, 2007 at 08:03:13 Pacific OS: win xp home CPU/Ram: Pent 4/ 1012 Product: dell
Comment:
I have a spreadsheet that adds up rows and columns for me using COUNTIF. For some strange reason it has suddenly stopped changing totals as I change the cells. It only updates the totals if I save the work. This is useless to me as it is a duty rota sheet and I have to fiddle with it to get hours and numbers of staff right and need to try different things before I save stuff. Have no idea what I've done to make it behave like this - all ideas appreciated! thanks
Name: wizard-fred Date: March 24, 2007 at 02:46:55 Pacific
Reply:
In the old days of the 4.77 MHz CPU there was a feature of manual recalculation to allow you to enter data in several cells before the spreadsheet was recalculated. Otherwise you would have to wait for the spreadsheet to recalculate before you could enter data in the next cell. In Lotus 123 I had spreadsheets that took over 5 minutes to calculate.
In Excel Check Tools, Options, Calculation. I think you will find that it has been set to Manual.
Summary: When I copy formulas, they are not updated as they are supposed to, ie. when copying a formula like =A1 from B1 to B2, the new formula in B2 becomes =A1 and not =A2 as it's supposed to when not using ...
Summary: The text in the email if i want to send the file through excel it automaticaly opens a new email with the attachement, and when i type instructions in the body of the email just the attachment gets th...
Summary: I have imported data into Excel from an Acess query. My problem is that it does not update unless I delete the query and re-import. I think it's because it's embedded and not "linked." I need it to up...
0 
