Home

Excel Workbook Error Trying To Open

secm-1972
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies