Home

Old File Freezes. Only option to recreate?

%3CLINGO-SUB%20id%3D%22lingo-sub-816155%22%20slang%3D%22en-US%22%3EOld%20File%20Freezes.%20Only%20option%20to%20recreate%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816155%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20a%20file%20that%20goes%20back%20to%201999%20that%20I%20use%20on%20a%20weekly%20basis.%20It%20is%20currently%20about%207%2C500%20KB.%20Every%20time%20I%20open%2C%20close%2C%20and%20save%20the%20file%2C%20it%20stalls%20for%20a%20good%2010-15%20minutes.%20There%20is%20also%20a%20single%20tab%20within%20the%20file%20that%20references%20the%20other%20tabs%20and%20it%20is%20this%20tab%20that%20freezes%20and%20sometimes%20crashes%20the%20file.%20I%20have%20a%20very%20powerful%20computer%2C%20too.%20I%20can%20use%20other%20applications%20while%20I%20run%20this%20sheet%2C%20so%20I%20know%20the%20computer%20is%20not%20the%20issue.%20Anyways%2C%20I%20am%20looking%20for%20some%20tips%20or%20advice%20on%20how%20I%20can%20resolve%20this%20issue.%20My%20IT%20team%20and%20our%20internal%20Microsoft%20applications%20team%20only%20solution%20as%20ofright%20now%20is%20to%20recreate%20the%20sheet.Thanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-816155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816162%22%20slang%3D%22en-US%22%3ERe%3A%20Old%20File%20Freezes.%20Only%20option%20to%20recreate%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816162%22%20slang%3D%22en-US%22%3EThe%20sheet%20has%20only%20a%20few%20functions%20that%20pull%20from%20Bloomberg%2C%20but%20for%20the%20most%20part%2C%20all%20functions%20are%20contained%20within%20the%20sheet.%3C%2FLINGO-BODY%3E
Rocco2180
New Contributor
Hi, I have a file that goes back to 1999 that I use on a weekly basis. It is currently about 7,500 KB. Every time I open, close, and save the file, it stalls for a good 10-15 minutes. There is also a single tab within the file that references the other tabs and it is this tab that freezes and sometimes crashes the file. I have a very powerful computer, too. I can use other applications while I run this sheet, so I know the computer is not the issue. Anyways, I am looking for some tips or advice on how I can resolve this issue. My IT team and our internal Microsoft applications team only solution as ofright now is to recreate the sheet.Thanks
1 Reply
The sheet has only a few functions that pull from Bloomberg, but for the most part, all functions are contained within the sheet.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 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
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies