Nov 29 2021 05:01 PM
Excel for Office 365 16.0.12527.22049 64-bit
Windows 7 and Windows 10
We have two workbooks that are templates. One is used for around 150+ projects a year. This workbook has the issue. The second workbook is a similar template that is used for about 50 projects a year. This workbook does not have the issue.
Problem:
When saving a workbook using the one template that is used for 150+ projects/Yr, the save now takes 7 to 10 minutes with the "Saving (Not Responding)" message. This just started on Friday 11/26/2021. The day before there were no issues. Workbooks from this template that had previously saved quickly no longer save quickly. Workbooks from the other template continue to work correctly.
There does not appear to have been any updates applied to the system.
This is happening to all users with workbooks based on the one template, but not the other.
The workbooks started from similar designs and use similar operations. They both have 75+ very hidden data tables used for dropdowns. The data tables query a SQL DB. HLookups and VLookups are used. There are several hundred field names. There is an Excel Add-in containing numerous functions. There is also a third-party VSTO add-in. This cannot be turned off (except maybe running in save mode). There are no external linked files.
Have tried:
At a complete loss as to what to look at next.
Nov 30 2021 05:06 AM
Nov 30 2021 05:40 AM
Nov 30 2021 05:44 AM
@KTerrell32707 1. How "clean" is your file? 2. Any VBA code running?
Nov 30 2021 10:08 AM
@Jan Karel Pieterse. Yes, there is VBA running. It is all in an Excel add-in (Macros in an excel file that is added as an add-in). A third party that wrote VSTO code that disables menus, adds a tab to the ribbon and does not allow the workbook to be macro enable, so there are no macro's local to the workbook, only in the add-in. The add-in is an Excel add-in. We unchecked it under add-ins (disabled) and still have long saves.
As for clean, this happens to all workbooks that are based on this template workbook (copy of) and on this master.
Nov 30 2021 10:10 AM
Nov 30 2021 10:36 AM
Nov 30 2021 02:30 PM