When I change my data, my formulas don't update the answers,why?

ayprlthing

Posts: n/a

When I change my data, my formulas don't update the answers,why?

I have a personal finance sheet that has basic formulas which I update monthly.

However, if I change a data cell, the other cell which has a formula linked
to it does not pull the new data cell information. The formula is correct.
The only way to "fix" my problem is to retype the exact same formula and then
it pulls the new data.

Any advise?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Cell references change when entering new data	[email protected]	New Users to Excel	2	May 6th 05 07:48 PM
1-variable Data Table dependent on MS Query fails to update correctly	[email protected]	Excel Discussion (Misc queries)	0	March 30th 05 07:43 PM
Help with data not getting plotted	Scott Ehrlich	Excel Discussion (Misc queries)	2	January 25th 05 05:17 AM
Weekly Transaction Processing	Ralph Howarth	Excel Worksheet Functions	4	January 19th 05 05:37 AM
how do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM

All times are GMT +1. The time now is 08:45 AM.

Menu

About Us