May 16 2022 03:10 AM
Hello,
I've written an Excel spreadsheet with 60+ worksheets. Every link between the worksheets updates automatically when I add in a new worksheet - except one.
On a summarypage at the front of the spreadsheet, I right clicked on a particular cell and added a link to a cell in another worksheet. But when I've added a new worksheet, that cell number does not update automatically, even though I've not set it as absolute. I've tried everything I can think of, but to no avail. Any ideas? I'm thinking that it has to be something simple that I've just not thought of. All ideas appreciated, thanks.
May 16 2022 09:07 AM
May 17 2022 07:21 AM