M
Matt FERG Ferguson
Okay, so I've copied and pasted links within a large
workbook (19MB), across several worksheets within the
workbook. My pasted links are not updating whenever I
change the values in the original cell. I press F9,
nothing. Go up to calculate now, nothing. Close and re-
open the file, nothing. The only thing that seems to work
is to click in link cell (as if to edit it), and then
press enter. This is really cumbersom for the 200+ cells
that I would have to do that to. How can I make excel re-
update ALL of the links and calculate ALL of the cells in
a workbook (Excel 2002), regardless of whether it thinks
I've changed anything?
workbook (19MB), across several worksheets within the
workbook. My pasted links are not updating whenever I
change the values in the original cell. I press F9,
nothing. Go up to calculate now, nothing. Close and re-
open the file, nothing. The only thing that seems to work
is to click in link cell (as if to edit it), and then
press enter. This is really cumbersom for the 200+ cells
that I would have to do that to. How can I make excel re-
update ALL of the links and calculate ALL of the cells in
a workbook (Excel 2002), regardless of whether it thinks
I've changed anything?