one set of excel files on shared folder opens slower (very) than others

psunith

New Member
Joined
Oct 18, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
we have a set of excel files and the biggest one is only 1.35Mb. When we open these files they take longer than usual and longer than our liking to open. the files are stored in a QNAP NAS shared folder. The shared folder is mapped to several users.

We have tried opening these files with 4 users and its the same, it takes a while for the excel app to open, then shows the percentage of the file opening and then opens.

we are on M365 with Excel 2016 fully updated. These files are in the same folder and have been using the same template from 2014 and files are saved year wise, the opening very slow issue is with all these files. We have much larger excel files on different folders and we have no such issues, its just these set of files.

Any advise on what we can do to make it work normally?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: link supplied in post#2
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0

Forum statistics

Threads
1,214,929
Messages
6,122,315
Members
449,081
Latest member
tanurai

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
Back
Top