palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have a spreadsheet with numerous macros that seems to be doing two saves when I click to save the file to a shared drive .... G: drive at my workplace.
On clicking to save to the shared drive (G: drive), I get the usual swirling hourglass for about 6 to 10 seconds ... this is what I have always seen the save to G:drive do ... no indication to which drive it's being saved, but by checking later, you can see it has saved to G: drive as expected.
As soon as that save finishes, it launches into a second save, indicated by a 'Save As" and progress bar where it actually states it is being saved to G: drive ... I haven't seen this in the past with all my other spreadsheets (all which contain numerous macros etc) ... but this save takes in the order of 40 seconds to a minute.
The file is only 18 000 KB, no bigger than my other files, so I wouldn't be expecting it to take this long, or to do this strange 'double save'.
Also, opening the file used to take only a few seconds, now it takes more than 40 seconds.
When I open and/or save the very same file in my own external hard-drive, it opens in just 3 seconds, and saves in about 5 seconds.
I've googled the terms 'excel double save', and have found nothing except one solitary forum chat (not this site) from several years ago where someone was experiencing the same problem. A contributor commented ....
The "double saving" occurs only when I'm running Excel within
the Citrix Presentation Server Client. When I'm running Excel by
itself, the "save" happens only once.
I have no idea what that means, but maybe one of you does.
Does anyone know what has happened, and if there is a solve ?
I'm running Excel 2013, and the file is saved as a .xlsm (macro enabled) file.
Kind regards,
Chris
On clicking to save to the shared drive (G: drive), I get the usual swirling hourglass for about 6 to 10 seconds ... this is what I have always seen the save to G:drive do ... no indication to which drive it's being saved, but by checking later, you can see it has saved to G: drive as expected.
As soon as that save finishes, it launches into a second save, indicated by a 'Save As" and progress bar where it actually states it is being saved to G: drive ... I haven't seen this in the past with all my other spreadsheets (all which contain numerous macros etc) ... but this save takes in the order of 40 seconds to a minute.
The file is only 18 000 KB, no bigger than my other files, so I wouldn't be expecting it to take this long, or to do this strange 'double save'.
Also, opening the file used to take only a few seconds, now it takes more than 40 seconds.
When I open and/or save the very same file in my own external hard-drive, it opens in just 3 seconds, and saves in about 5 seconds.
I've googled the terms 'excel double save', and have found nothing except one solitary forum chat (not this site) from several years ago where someone was experiencing the same problem. A contributor commented ....
The "double saving" occurs only when I'm running Excel within
the Citrix Presentation Server Client. When I'm running Excel by
itself, the "save" happens only once.
I have no idea what that means, but maybe one of you does.
Does anyone know what has happened, and if there is a solve ?
I'm running Excel 2013, and the file is saved as a .xlsm (macro enabled) file.
Kind regards,
Chris
Last edited:
