MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Links wont update


Posted by Shazadi on March 09, 2001 1:32 PM

I have cells where I have asked them to gather information from other cells using this format:

=H9

and even the functions such as SUM and whatnot wont update automatically when I change the reference cell content.

Under Edit, Links, I have it check marked to update automatically.

Can anybody guess what the problem might be?

HELP AGAIN!

yours truly,
frustrated to all hell Shazadi


Posted by Mark W. on March 09, 2001 1:44 PM

Well, let's see... Does it say, "Calculate", on
Excel's status (lower) bar? If so, your
calcuation mode is probably set to Manual. To
check and/or change this use the Tools Options...
menu command, click on the Calculation tab, and
choose the Automatic option.

Posted by Dunk on March 09, 2001 4:48 PM

True, but ...

... what if you don't want everything to update at this point. I have been down this road as well and when you turn the Calculations back to automatic, all formulae on all pages run again.

How do you get a selection of cells to calculate?

Posted by Mark W. on March 09, 2001 10:49 PM

Re: True, but ...

It's all or nothing... unless you go to each cell, press F2 and enter.

Posted by Dunk on March 10, 2001 9:54 AM

Thanks for the answer.

I guess I'll have to record a Macro to do that bit.