Excel Unreadable Content

R

rockyw

Well-known Member
Joined
Dec 26, 2010
Messages
1,196
Office Version
  1. 2010
Platform
  1. Windows
I have a workbook in Excel 2010 that after I use a sort macro when anyone reopens the workbook we get an error that says it has unreadable content. Then if you say yes we see a box that says.
HTML: 
Removed Records: Sorting from /xl/worksheets/sheet1.xml part
I never seen tis before until just a week ago and now I don't know how to get ride of it. Any help would be great, Thanks
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
Google Excel Removed Records, this seems to be a fairly popular error when sorting.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Removing Unreadable Content
Replies
8
Views
2K
Blue Cheeseburger
B
V
  • Locked
  • Question Question
adding pivot table causes error message when reopening file.
Replies
1
Views
116
Fluff
Fluff
V
  • Question Question
Pivot table cache
Replies
1
Views
184
GraH
GraH
S
  • Question Question
excel file saved in computer with older version excel
Replies
6
Views
804
Shloime
S
D
  • Question Question
Excel on Mac - file repair issues
Replies
1
Views
2K
dskills
D

Forum statistics

Threads
1,223,888
Messages
6,175,203
Members
452,617
Latest member
Narendra Babu D

Share this page

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