SingularitysPoint
New Member
- Joined
- Nov 20, 2015
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi all
We have a shared Excel file in a Teams channel. Everyone has the channel set as a Onedrive shortcut too, so it creates a daily backup of itself on the first opening each day using a Workbook_Open script. This script also sets a temporary view so people don't mess up what each other is doing, with everyone opening the file through Excel, rather than Teams.
For the majority of the time, this is working fine, with no issues. It still is, for most people. There's a couple of guys, however, who are having the following problem - they can open the file, but when they try to save it, it just freezes and sits spinning with a Not Responding message at the top. It was saving as soon as it had opened and ran the script (I assume due to running automatic calculations on startup), so I thought it was something in the code, but that's not the case. I made sure calculation were at manual and auto save was off so no initial save was attempted. It worked OK until I tried to save it, and the hanging occurred.
Weirdly, if I open one of the backups or just make a copy of the file and open that, everything is fine. So, it only seems to be affected when the file is open by others.
Does anyone have any suggestions?
We have a shared Excel file in a Teams channel. Everyone has the channel set as a Onedrive shortcut too, so it creates a daily backup of itself on the first opening each day using a Workbook_Open script. This script also sets a temporary view so people don't mess up what each other is doing, with everyone opening the file through Excel, rather than Teams.
For the majority of the time, this is working fine, with no issues. It still is, for most people. There's a couple of guys, however, who are having the following problem - they can open the file, but when they try to save it, it just freezes and sits spinning with a Not Responding message at the top. It was saving as soon as it had opened and ran the script (I assume due to running automatic calculations on startup), so I thought it was something in the code, but that's not the case. I made sure calculation were at manual and auto save was off so no initial save was attempted. It worked OK until I tried to save it, and the hanging occurred.
Weirdly, if I open one of the backups or just make a copy of the file and open that, everything is fine. So, it only seems to be affected when the file is open by others.
Does anyone have any suggestions?
