Hi Tubig
The absolute easiest way I can think of would be to record a macro of you selecting all worksheet cells (the button above the row numbering/to left of column lettering) and doing a Find/Replace on "=" with "=", which should force all externally referenced formulas in that sheet to update their values.
Hope this helps!
Hi Tubig
The absolute easiest way I can think of would be to record a macro of you selecting all worksheet cells (the button above the row numbering/to left of column lettering) and doing a Find/Replace on "=" with "=", which should force all externally referenced formulas in that sheet to update their values.
Hope this helps!
What happens when you replace the "=" with "="?