LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ozymandias
 
Posts: n/a
Default My formula doesn't update totals when I change numbers.

To be specific:
If I input 5 in cell A1, and input 6 in cell A2, and input =a1+a2 in
cellA3, the total is 11 for cell A3.

After I do that, let's say I change my input in cell A1 from 5 to 4. The
total in cell A3 should be 10. However, it stays at 11.
I only have this problem on my home computer, but not on my work computer.
This is driving me crazy, as it makes me lose trust in Excel's ability to
automatically update totals.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change a formula in one cell and have these changes appear Sam Excel Worksheet Functions 3 May 18th 05 10:57 PM
How to change a formula in one cell and have these changes appear Duke Carey Excel Worksheet Functions 1 May 17th 05 06:15 PM
macro to change numbers to names WAB Excel Worksheet Functions 3 April 16th 05 02:14 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
Displaying numbers used in formula SeeFar Excel Discussion (Misc queries) 2 December 28th 04 07:05 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"