Q: Prevent references from updating when deleting/replacing sheets
Howdy! I have a large Numbers spreadsheet with numerous identical sheets containing billing info for independent jobs. I also have a summary sheet which references (and aggregates) the values computed on each individual sheet.
I've been making incremental improvements to the individual job sheets, which are easy to duplicate x 20, however that breaks the references contained on the summary sheet, forcing me to update all 20 individual sheets with the exact same info. I'd like to be able to make changes to a single sheet, delete the other 19, then duplicate the new sheet 19 times, without the summary references breaking. Here is what I've tried:
Delete 19 of the 20 individual sheets; update one sheet as necessary, then duplicate x 19; References on summary sheet are broken, even if the new sheets are named exactly as the old.
I also tried renaming the old sheets, then replacing with a new sheet, named identically to the old, but the reference on the summary sheet is updated to point to the renamed sheets (it's too smart for me!).
Any ideas are greatly appreciated! Is there some way to turn off the automatic "follow me" updates so I can rename sheets without Numbers dynamically updating the formulas? This is typically a nice feature, but it's the very thing I DON'T want in this situation!
Posted on Oct 2, 2016 12:38 PM
