0

I have a google sheets doc linked to another sheets document via IMPORTRANGE.

I wish to have a duplicate which mantains Values only without the link data, since i am lookin to update the data and make like monthly reports based on that.

Is there a way to duplicate the sheets via script or another function or either break the links but mantain the values?

Pablo Aldana
  • 1

1 Answers1

0

Make the copy and enable the IMPORTRANGE(s).

Then select the entire sheet by clicking the blank rectangle just above the left-hand row numbers and to the left of the top column letters. With the sheet selected, click Ctrl-C to copy to clipboard.

With the full-sheet selection still active, hit Ctrl-V for "Paste Special." Look for a clipboard icon to appear lower-right on the visible screen area. Click it and choose "Paste values only."

Erik Tyler
  • 9,079
  • 2
  • 7
  • 11