Excel 2013 stripping out buttons and jpg images

spurs

Active Member
Joined
Oct 18, 2006
Messages
479
Office Version
  1. 2016
  2. 2013
  3. 2010
  4. 2007
  5. 2003 or older
Platform
  1. Windows
I am finding that as I convert workbooks from excel 2002 to 2013 or newer, there are times when saving the workbooks gives me an error message. This is sporadic and does not happen every time the workbook is saved.

The message basically warns me about corruption of the file and excel has to strip out elements of the file. What it ends up stripping out is on one worksheet only.

1) A company logo with hyperlink to the website - note that only the logo on one worksheet is stripped out - the others in the other worksheets are still there. When I copy and paste it from the other working worksheets back into the offending worksheet, it works and saves a few times then strips out again eventually on a save.

b) Macro buttons on the offending page. All other macro buttons in the workbook are not affected.


Any thoughts as to why this happens only on the one page?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Further update:
The file size is about 2 meg. I have 16 gig ram

Upon saving, the following message appears:

The document was saved successfully, but Excel cannot re-open it because of a sharing violation. Please close the document and try to open it again.

Upon opening the saved document, another message appears:

There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider: - using 64 bit version of Microsoft excel, - adding memory to your device.

After clearing his message, the same elements are stripped out of the same worksheet in the file again:
Company logo
macro buttons

the rest of the workbook is fine - including company logos and macro buttons

Any thoughts?
 
Upvote 0
Another update
I rebuilt the last worksheet from scratch and deleted the offending worksheet thinking something is corrupt

the same thing happened on the new worksheet !

Help !
 
Upvote 0

Forum statistics

Threads
1,216,099
Messages
6,128,816
Members
449,469
Latest member
Kingwi11y

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