0

Sames size of Excel files, it's much slower opened if it is in sub-folders,

For example:

C:\folder1\folder2\folder3\folder4\folder5\folder6\file.xlsx. 

It takes 30 seconds to be opened.

When the same Excel file is moved to:

C:\folder1\file.xlsx

It takes less than 10 seconds.

Running Excel 2016 in Windows 10. Just completed the Repair by Office. It's very fast if only launch Excel.

Is there a way to make the Excel file located in sub-folders to be opened quicker?

Thank you.

  • 1
    Make a hardlink to this subfolder near the filesystem's root and use short pathname. – Akina Aug 13 at 6:03
  • 1
    if the total number of characters in all the folders exceed 254 problems with opening files does happen. – JohnnyVegas Aug 13 at 6:34
  • 1
    Alternatively: subst x: C:\folder1\folder2\folder3\folder4\folder5\folder6 – Akina Aug 13 at 7:24
  • @Akina, could you please share more on the "subst" method? – Mark K Aug 13 at 8:22
  • 1
    Start CMD window. Type subst /? and press Enter. Or read somethink like this: docs.microsoft.com/en-us/windows-server/administration/… – Akina Aug 13 at 8:27
0

Just to share a way worked on my computer. My Excel no long takes abnormally long when opening spreadsheets after following the steps.

How To Fix ‘Filename Is Too Long’ Issue In Windows

In "Make Windows 10 Accept Long File Paths", with Registry Editor opened, navigate to the location:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\FileSystem

Double-click on LongPathsEnabled. In the Value data: field, make sure the number 1 is in there. Click OK.

Once the Group Policy Editor opens, navigate to:

Computer Configuration > Administrative Templates > System > Filesystem.

There the policy Enable Win32 long paths. Double-click on it to edit the policy setting. Change it from Disabled to Enabled, then click the OK.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.