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:


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?


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.