View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sanjish Kumar Sanjish Kumar is offline
external usenet poster
 
Posts: 1
Default How to copy a linked sheet

Hi,

I have sheet1 which is linked to sheet2 thru formula fields. Sheet1 displays
fine. But if I try to make a copy of it (Ctrl-C) and paste to another area of
the same sheet then the linked values are lost and 0 appears in all the
columns. How do I get over this problem as I need to make several copies of
sheet1 in the same sheet.


Please help

Thanks & Regards

Sanjish