I am stuck in a situation where I had a sheet in my App, which I used to show data for 2015. Then for advance planning for 2016 I had to create a similar tab but with data for 2016. So, I just copied the old sheet rename it.
Now, the problem is, if I make any change in new sheet, for ex: If I change any object, then the change is automatically cascading to old sheet. Which I do not want, I want old sheet to remain intact.
Any Idea or suggetions would be really appreciated.
The objects on the old sheet are probably linked objects, causing your changes to any copy to propagate to all the other copies.
On your new sheet, copy all objects to the clipboard, delete the current objects (you will get a dialog - do not delete all linked objects, just this selection) and paste the ones from the clipboard as regular objects, not as linked ones.
Thanks for prompt reply, I definitely want to try this way.
Now, I see one more problem. The objects in my old sheet have already been changed.. And it would be very difficult to restore them. As, there are so many pivots inside container. And I have changed so many columns in it.
However, I have an old copy of app. So, is there any way I can copy and paste objects from old app to new app.
If you feel like you have had an answer to your question, close the discussion by marking an answer as correct. That way, other community members looking for a solution to a similar problem will find one here.
However, it is still not done. Even I am trying to copy objects from old version. But as soon as I paste them to the new app, they are changing themselves as per the new sheet in new app.
How exactly are they changing themselves? Do they align with your style settings (e.g. colors, transparency and such) or do they fold (probably caused by changed expressions, missing fields or different field names)?
That s the issue, while replacing it takes the object ID , No don't delete the new objects...you want to replace the edited objects with the old ones rite?? for that you can delete the modified old once with the back up objects.
