Duplicating a Large Workspace
I've run into a bit of a problem...
I have build a rather large workspace. Everything ties together. It consists of 147 sheets, reports, and dashboards spread throughout various folders for organization. There is A LOT of cell linking and cross sheet references in various forms for various reasons.
I was recently informed that the workspace needed an overhaul. Some services we were tracking are being dropped, and new services are being added. This will affect literally every aspect of this workspace.
What I want to do is to "Save as new" the entire workspace, so I can do some preliminary testing on changes to make sure I have everything covered without affecting the current workspace as it will be in use until the new one is rolled out with the updates.
Here's the problem... You can only save up to 100 items. I have 147 not including folders.
If I save it in sections, I will have to go through and re-link everything and update all cross sheet references to the new sheets. Some of these sheets are close to maxing out on the cross sheet references. Re-linking and and updating everything to reference the new sheets will be a massive undertaking in and of itself, and I don't have that kind of time or energy.
Is there any way at all to get around this "100 item" limit so that I can take advantage of everything being automatically linked to the new sheets?