Err msg during open workbook...I lost every data from..

This is an open forum.

Questions remain on the Forum and no payment is required unless you choose to post in the hire help forum.

When these problems occur it is best not allow Excel to attempt a repair, but to then try moving everything to a new workbook

What do you that you thought we were professionals.

If you haven't kept a backup copy then he chances are that your work is lost You can try some software that may recover it for you. Google for such software, most have trial versions to test with.

We can't tell you what you did wrong, this error has multiple causes. If you have a backup copy we could look at that to see if there is problem with the code.

You must start keeping frequent backups of your code so that if this error occurs then you won't lose everything, you can go back to the previous version.

Also, I have found if I the error occurs say no when prompted. If the workbook closes at that open it without enabling macros and then do as I said and move everything to another workbook.

Here's some software that claims to recover corrupt Excel workbooks.

If you have a backup then attach it and I will see if I can spot any errors

Here's an old file I have on my computer giving some suggestions

It's really difficult without seeing the workbook and code. Then it's not always possible to replicate the error.

The Forum does not work like that, can you remove sensitive data?

I can't open that zip file on Win10.

The zip file opens for me, but the workbook won't open. It gives the error message, but won't open if I select No

Have you got an earlier version that you can use or upload?