Member Avatar for ggeoff

Hi

I thought this was easy. I want to copy a spreadsheet in a workbook to a new spreadsheet in the same workbook preserving links.
So as the source worksheet received new entries the copied spreadsheet would be updated.

My reason being that I would introduce some variation in the way that data was computed on a few lines.

  • 3 Contributors
  • 3 Replies
  • 245 Views
  • 8 Months Discussion Span
  • Latest Post Latest Post by bobbyraw
Member Avatar for DaveAmour

Can you not just copy and paste?

Edited by DaveAmour
Member Avatar for ggeoff

Thanks DaveAmour. I have tried but Paste Special is by degault set to "All" but that does not include the links in each cell to to the copied worksheet. If I sealect "paste link". THe program cannot make the changes reports the time it would take and then fails due to lack of resources. I am only running Outlook and Excel.

Member Avatar for bobbyraw

i want to make sure i understnd the request. you want to copy all data in lets say sheet 1 to sheet 4 and maintain all your formulas. is that correct? and if you ricg click sheet 1 and choose copy or move and seleft sheet 4 it does not work. am i corerct here also.
the next thing you can do is press Ctrl+~ this will show all your formulas, then press Ctrl+A to select every thing. then go to sheet 4 and select cell A1 and then press Ctrl+V this past all your formulas in the new sheet 4, then you can press Ctrl+~ to hide the formulas again.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.