Is cell linkage within a row affected when I move/archive a row in my source sheet to a new destinat
My source sheet is getting larger by the month and we are going to need to move rows out of it so I'd like to set up an automated workflow that moves a row that has been "verified" with a check box out of the source sheet to a new destination sheet. But there are cells in these rows I want to move that are linked to other sheets across our workspace. So my question therefore is: Will these cell linkages stay intact when I move from source sheet to destination sheet?
Best Answer
-
They will not. Cell links and formulas are not pulled when copying or moving a row. Only the static data is preserved.
Answers
-
They will not. Cell links and formulas are not pulled when copying or moving a row. Only the static data is preserved.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives