Copy Sheet doesn't update relative references

C

CLC_Mac

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In 2004 When a sheet was copied, the embedded formula's referenced the current sheet and not the sheet that was duplicated. That made it very easy to rename the sheet and have the references update. Now that doesn't do it. This is a huge missing feature.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlighting top row to last row in sheet 2
Adding the content of multiple sheets to a consolidated sheet 2
Ledger template shows $ when internationalsetting is £ 4
Adjusting sheet size 1
Different Colored Sheet Tabs in Excel? 1
Structured References 0
relative reference to previous sheet in formulas? 1
Managing multiple worksheets 2

Top