Some links not updating

Copper Contributor

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.

3 Replies
convertir las columnas a filas en un cuadro
como hacerlo sin alterar la información de la tabla
Thanks for your reply, but I don't see how that would help the link to update automatically? Thanks though.