Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I created some charts based on my requirement and I was unable to do copy and paste of particular chart(in the same sheet and another sheet nothing was worked). I tried clone, copy and paste object and so on but nothing has shown up. Could any one suggest me what might the reason for this ? Please tell me how can I do this.Thanks
Are you able to see "Paste Sheet Object" option active when you right click on the sheet?
Please share screenshot if possible.
you may check your sheet security or document security.
Can you please explain Is your copy paste not working or the charts are not being calculated?
If your copy paste is not happening to check the security of the sheets.
Sheet Properties --> Add Sheet Objects has to be checked in the destination
Sheet Properties --> Copy/Clone Sheet Objects has to be checked in the Source
Also, on the same note check the layout properties of the chart if any conditions are enabled.
As Sudeep mentioned, check document properties as well,
Settings --> Document Properties:
Then go to Layout tab:
Only my copy paste option is not working. Now, it works. Thanks much.