View Single Post
  #1   Report Post  
Gordon
 
Posts: n/a
Default

ADC wrote:
Thanks for your feedback. This is what I assumed was causing the problem.

I have tried various other alternatives. The worksheet is a highly formatted
summary of data calculated on other sheets within the workbook. I tried
copying the sheet to a new workbook by right clicking the tab and clicking on
Create a Copy. The problem is it creates a new workbook linked back to the
original.


Once you have made a copy of the sheet, select the whole sheet and do a
Copy-Paste special-values. That will get rid of the links.



--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(9 days and counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!