Workbook won't open but if another person opens it and save it it will open

krodriguez

Board Regular
Joined
Jul 11, 2012
Messages
118
Hello,

I have this excel file that is in a shared drive, sometime this file will not open or will crash trying to open, but when another co-worker opens the file (yes they can open it) and saved the file with another name then it will work for me.

Any ideas why this could be happening?

Thanks!
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

jjasmith4

New Member
Joined
Aug 22, 2018
Messages
48
I'd try running Disk Cleanup on your machine. Close down ALL applications first, then open Explorer, right-click the C: drive, choose Properties, choose the Tools tab and click Disk Cleanup.

Is the file shareable? Maybe the other user should open it, make it unshareable, confirm removing change history, make it shareable again, then save and close it.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,401
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top