Shared workbooks in shared drives suddenly extremely slow to open

bnbcat

New Member
Joined
Apr 27, 2016
Messages
38
Office Version
  1. 2016
Platform
  1. Windows
Please let me know if this needs to be posted elsewhere.

I do FP&A for a matrix organization and we ended up with horrid templates that 1) have to be shared files so all the teams have the ability to write their commentary at the same time, 2) link to each other so the parent region files pull in the commentary from the sub regions and 3) files live on 4 different shared drives located around the globe.

The files are bulky and annoying because they're shared files and live in different shared drives, but still functioned relatively normally every month for the past 1.5 years. However, over the last month for me and others, the files are taking ages to open, like 5-10 minutes.. some people have even waited 20 minutes or so. The files often crash as well. I even have trouble opening files that have opened fine in the past, nixing the idea that it could be a problem with the newer files. It's also strange because while half of us are miserable because of these files, there are also people that have no troubles at all. Unfortunate our IT team is not doing anything to help the situation.

I believe everyone is on Excel 2016 and a majority of people are working from home (though this has been the case for the past year as well).

Does anyone have any ideas on what could be causing this issue?

P.S. I know the file setup we have is bad, and we initially wanted to use Sharepoint... but it was not compatible with our version of Excel and our financial planning software.
 

Excel Facts

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

Forum statistics

Threads
1,141,818
Messages
5,708,768
Members
421,588
Latest member
Wawie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top