Excel Workbook Error Trying To Open

Occasional Visitor

We have a excel workbook that we do our estimates for a very large steel fabricating company in. This work book is about 60mb and has various macros and things like that running in it... but here is the problem... there are times when User1 opens a workbook and inputs the data for the estimate, then User2 opens and inputs more data, and then User3 tries to open it the workbook just hangs up while trying to open and nothing we can do will fix it. The only resolution we have found is to select any random users computer from the network, open the file, then save and close it and then it will open from User3's computer. There is no particular rhyme to how many times a work book is opened or by how many people open it before it does this. Any ideas?

1 Reply
So are the 3 users opening the file alternately or at the same time?

Could try saving it as a .xlsb file (assuming it's currently a .xlsm file)

Sometimes that can help with Big files.
Related Conversations
Room Booking using Excel
Maddie1215 in Excel on
0 Replies
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies
Resizing table Error
birkettsl in Excel on
1 Replies
Conditional formatting assistance please
c_frndz in Excel on
4 Replies
delete one marging
fred83 in Excel on
4 Replies