I have a table that is about 2 lines long (to show sample data). This table's sheet is referenced from another sheet. The problem is, when I add a column to the table, the formulas on the referenced sheet auto-update and destroy the reference, sometimes even changing to "Ref!" errors. I will email the sheet to someone who elects to help, but I don't want to post it because it is based on one of Chandoo's purchased sheets.
When I wrote the code, I had 150 lines of data. I deleted the data, and got the table correct.
The problem becomes, how do I cause the linked sheet to update its formulas to correspond to the table, or prevent them from updating at all, and referencing the absolute cells?
PS. This is not an "Absolute" vs "Relative" problem. It has to do with Excel updating formulas automatically when references are changed elsewhere.
Thanks for any suggestions, offers, or input,
Don
When I wrote the code, I had 150 lines of data. I deleted the data, and got the table correct.
The problem becomes, how do I cause the linked sheet to update its formulas to correspond to the table, or prevent them from updating at all, and referencing the absolute cells?
PS. This is not an "Absolute" vs "Relative" problem. It has to do with Excel updating formulas automatically when references are changed elsewhere.
Thanks for any suggestions, offers, or input,
Don