Problems with sharing a workbook

[Even]

Hi,

after finishing up my Excel model with a lot of help from you guys I am trying to share the workbook with multiple users. I have followed directions found on the Internet, but I get an error message when I try to open it in shared mode. The message is : "We found a problem with some content in "x file.xlsm". Do you want us to try to recover as much as we can?" It opens when I click yes, but I can't save it with the same name. It only has this problem in the shared version.

The file has many macros.

Does anybody know what the problem is and how to fix this?


Even

 

[jasonb75]

Have you tried saving with a new name then checking to see if that version works correctly?

If it does then it should be as simple as deleting the original one then changing the name of the new one to whatever the original was called.

 

[Even]

Thanks, but it didn't work. However, when I clicked on yes to try to recover it, I was able to open it by "repairing or removing the unreadable content: Removed Records: Named range from /xl/workbook.xml part (Workbook)". I don't really know what this means though. Do I have a named range somewhere that it doesn't understand?

 

[jasonb75]

It would be corrupt more than something that is not understood. If there was an error in a named range definition then it would still open properly, you would simply see #NAME? errors in the data where that named range was used.

If the named range has been repaired / removed then the next step would be to investigate the range that was specified to see if it is still there and functioning as needed, if not then make any changes needed to fix the problem from there.

The cause could be one single thing, or multiple things conflicting to cause a problem (depending on the complexity of the workbook). Even the simplest of shared workbooks tend to be unstable. I have used them in the past but they are best avoided where possible.

 

[Even]

Very annoying.

Thanks

 

[logstarter]

Very annoying.

Thanks

Hi, Even,

Unfortunately I got the same issue but my file do not have any macro.. Just want to ask if your issue is solved? Thanks.

 

[Even]

Yes, actually I did. After many trials and errors I found out that I had a corrupt sheet within the workbook. The sheet was actually the front page where I had several boxes and I also had set a print area together with frozen cells.
I hope you figure it out