+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    10-17-2021
    Location
    Dubai
    MS-Off Ver
    2016
    Posts
    1

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

    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?

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

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

    Hi

    Welcome on forum.
    Please read Forum rules (especially #3 about cross-posting).

    Cross-post here: https://www.mrexcel.com/board/thread...thers.1184945/
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to delete all files in folder from shared excel file
    By A9kurs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2021, 12:41 PM
  2. Excel 2013 VBA - Operning CSV file in loop becomes slower and slower
    By maruthu22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 12:36 AM
  3. Excel Spreadsheet running VBA macros gets slower and slower over time
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2017, 01:31 AM
  4. Replies: 1
    Last Post: 09-01-2016, 01:40 PM
  5. [SOLVED] VBA to Search for files in a Folder and Opens it
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-05-2014, 04:38 PM
  6. Replies: 4
    Last Post: 05-20-2013, 08:31 AM
  7. Excel opens all files in My Documents folder
    By Dave B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1