|
Well that was kinda a dirty solution but it worked so who cares.
On occasion I have had some quirks with spreadsheets which defied logic and this solution has worked most times.
Careful that none of the formulas refer to the original sheet it will appear to work until you move the file to a new machine.
|