We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover as mu

**AJVM** · 05-09-2018, 02:05 PM

Hi I'm sorry, I'm a newbie with excel..

I get an error after closing and reopening the excel book. I tried to lookup the issue, I tried everything I could find.
I am able to compile and run the vba, but soon as I save it and reopenit, i get the message below.

"We found a problem with some content in "XXXXX.XLSM". do you want us tor try to recover as much as we can? if you trust the source of the workbook. click yes."

I've changed the Trust centre settings for the ActiveX Settings / Macro Settings / Trusted Locations. saved as an excel 95 file and recreated as an xlsm file. verifying any references.
I'm trying to adding an activeX Command button (I even tried to put a Form Control button) to the excel sheet.
I've even tried renaming the sheets.

Capture.PNG

In the attached image, after I say yes to the error, excel creates a new "Sheet1" object and moves the original "Sheet1" object to a new sequence number, in the image above, the original sheet was renumbered to "Sheet3"..

Any help would be greatly appreciated

here is the code for the button click event, it's simply copying and pasting columns to new area (there is a data validation list that i'm getting form another page).

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

**mjr veverka** · 05-09-2018, 04:47 PM

If you can, transfer the data (as values, without formats and formulas) to the new workbook, recreate the formulas in it. Delete the old workbook.
Maybe it's damaged, it happens.

**scottiex** · 05-09-2018, 06:48 PM

Do you have an old copy of the sheet or a backup?
If so, you could open the file using a zip programme and copy the vba project from the backup onto the new excel sheet.
You could also do this from a similar sheet and just manually fix/copy over any VBA that was changed.

**AJVM** · 05-09-2018, 10:02 PM

Hello scottiex,
Yes, have a copy in GIT, I will try that. I'm not familiar with using a zip to copy the program vba project from the backup onto the new excel sheet. but I will investigate.

Hello porucha vevrku,

I did try that and then recreated the vba in the new excel sheet, it's strange because I can save and reopen the file without any issue, but as soon as I run the code
(it compiles, and runs with no issues), yet once I save it then try to open it again i receive the error.

I really appreciate the guidance! I'm am not very familiar with vba/excel.

AM

**AJVM** · 05-09-2018, 10:03 PM

Hello scottiex,
Yes, have a copy in GIT, I will try that. I'm not familiar with using a zip to copy the program vba project from the backup onto the new excel sheet. but I will investigate.
Sorry I usually don't post.

Thanks for your help.
AM

**AJVM** · 05-09-2018, 10:04 PM

Hello porucha vevrku,

I did try that and then recreated the vba in the new excel sheet, it's strange because I can save and reopen the file without any issue, but as soon as I run the code
(it compiles, and runs with no issues), yet once I save it then try to open it again i receive the error.

I really appreciate the guidance! I'm am not very familiar with vba/excel.

AM

**xlnitwit** · 05-10-2018, 02:45 AM

Hi,
I’d bet that your list for the data validation is over 255 characters, which is over the limit. You’re getting the items from a range anyway so you should just use the address of that range.

**AJVM** · 05-10-2018, 06:44 AM

Hello xlnitwit,

You guys are awesome!! I'd be willing to bet you are correct, I will test it shortly and reply. There are 227 rows in the result set that i'm returning from SQL (in my test).

THANKS!!!!
AM

**AJVM** · 05-10-2018, 06:45 AM

Hello xlnitwit,

You guys are awesome!! I'd be willing to bet you are correct, I will test it shortly and reply. There are 227 rows in the result set that i'm returning from SQL (in my test).

THANKS!!!!
AM

**AJVM** · 05-10-2018, 07:20 AM

THANK YOU porucha vevrku , scottiex and xlnitwit for responding!

xlnitwit, you were absolutely spot on, with the 255 character limit. I was definitely exceeding. I am now able to open and close the sheet with no issues.

I'm not 100% clear on how I can use the "Address of the Range". won't the "Address of the Range" appear in the drop down list? I'm sorry, up until 5 days ago, I had not touched vba or macro's, especially in excel.
In my test scenario I have a list of 227 row / items. In production I think it will be limited to under 100 items.

I have code that will allow me to populate a combo box with the same information, but I don't know if i can / or how to, dynamically link the combo box to a specific excel Cell.

THANK YOU SO MUCH FOR ALL OF YOUR HELP!
AM

**xlnitwit** · 05-10-2018, 07:25 AM

You might replace this part at the end

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

**AJVM** · 05-10-2018, 07:51 AM

OMG xlnitwit! That's awesome! It worked perfectly! Thank you all so much!

**xlnitwit** · 05-10-2018, 09:23 AM

You're welcome.

Thanks for the rep.

**Heathy65** · 03-12-2019, 12:42 PM

Originally Posted by xlnitwit

Hi,
I’d bet that your list for the data validation is over 255 characters, which is over the limit. You’re getting the items from a range anyway so you should just use the address of that range.

Just found this post when searching to fix an issue I had re. the "problem" error and yup my data validation is > 255. Thanks for posting this originally. I just wish MS gave a more useful error in the first place.

**Dofkinis** · 02-04-2020, 06:23 AM

Originally Posted by xlnitwit

Hi,
I’d bet that your list for the data validation is over 255 characters, which is over the limit. You’re getting the items from a range anyway so you should just use the address of that range.

That's a fix! Thank you!

**tuinkiz** · 02-18-2021, 08:59 PM

Originally Posted by xlnitwit

Hi,
I’d bet that your list for the data validation is over 255 characters, which is over the limit. You’re getting the items from a range anyway so you should just use the address of that range.

I have similar issue, thanks God, I found this forum with perfect answer.
Thank you xlnitwit & excelforum.

We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover as mu

LinkBack

Thread Tools

Rate This Thread

Display

We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover as mu

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Re: We found a problem with some content in XXXXX.xlsm. Do you want us to try to recover a

Thread Information

Users Browsing this Thread

Similar Threads

Excel Error "Excel found unreadable content do you want to recover?"

Excel found unreadable content in *****.xlsm

[SOLVED] Excel found unreadable content in filename.xlsm'. do you want to recover.....

Excel error - Unreadable content found in filename.xlsm, do you want to recover

Excel found Unreadable content in........xlsm do you want to recover contents of this...

Getting: "Excel found unreadable content in 'MyWorkbook.xlsm'..."

[SOLVED] Unreadable content found in .xlsm but not .xlsb. Why?

Bookmarks

Bookmarks

Posting Permissions