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.
 
Top