Copy sheet leaves graphics behind

melodramatic

Board Regular
Joined
Apr 28, 2003
Messages
180
Office Version
  1. 365
Platform
  1. Windows
I'm trying to do a copy sheet (tab, Move or Copy, Create a Copy, OK), and am having a problem. Any graphics I have on that sheet are not being copied over.

I've got several sheets that I need to copy, and it's happening whether the graphics are at the top, bottom or middle of the page.

I didn't have a problem with this until recently, and coincidentally, we upgraded to Office 365 recently. I'm suspecting this is one of those Microsoft oops upgrades.

Has anyone else seen this, and do you have a fix for it?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
I use 365 and do not see that behaviour :unsure:
What happens when VBA used to copy the active sheet?

VBA Code:
Sub CopySheet()
    ActiveSheet.Copy Before:=Sheets(1)
End Sub
 
Upvote 0
OK, after some playing back and forth on different computers, our I.T. finally figured out that somehow or another, it was linked to my profile on my computer only. Using the same file, I could copy sheets with graphics correctly on any other computer, and we had someone else log in on my computer and it worked fine.

Whatever it was, it took creating a new profile on the computer, and that took care of it. Weird!
 
Upvote 0

Forum statistics

Threads
1,215,523
Messages
6,125,322
Members
449,218
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top