cedricthecat
Active Member
- Joined
- May 17, 2007
- Messages
- 460
Just been forced to do an update of W10 (to Version 1803)
I use Excel 2003 (although I also have 2007) as I just prefer it, and this morning, after the update was done, noticed a couple of .xls files opened and then immediately closed without warning, effectively an Excel crash I think as they were in the list of recently auto-saved files on re-opening
All then seemed to have settled, until I just tried to open a file which is actually on my OH's laptop, which is networked to mine (it's a file we both access daily). This file has a single cell link reference to another one on her laptop. On opening the file, I got the prompt to update the link contents, then Excel just closed and vanished. I then tried dragging the file to my desktop, and it did the same. Next step was to try it in 2007 and it opened fine, so I tried dropping the link, closing and re-opening in 2003. This new version did allow me to open in 2003, but when closing, this VBA failed
So, nothing really obvious as to what is going on here. All of my other files (as checked, so far) seem fine
I can of course use 2007 for this file, but I'd rather get back to being able to use 2003 and thus need to get to the bottom of this
Has anyone else come across issues following the 1803 upgrade?
I use Excel 2003 (although I also have 2007) as I just prefer it, and this morning, after the update was done, noticed a couple of .xls files opened and then immediately closed without warning, effectively an Excel crash I think as they were in the list of recently auto-saved files on re-opening
All then seemed to have settled, until I just tried to open a file which is actually on my OH's laptop, which is networked to mine (it's a file we both access daily). This file has a single cell link reference to another one on her laptop. On opening the file, I got the prompt to update the link contents, then Excel just closed and vanished. I then tried dragging the file to my desktop, and it did the same. Next step was to try it in 2007 and it opened fine, so I tried dropping the link, closing and re-opening in 2003. This new version did allow me to open in 2003, but when closing, this VBA failed
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Range("SheetName") = ActiveSheet.Name
End Sub
So, nothing really obvious as to what is going on here. All of my other files (as checked, so far) seem fine
I can of course use 2007 for this file, but I'd rather get back to being able to use 2003 and thus need to get to the bottom of this
Has anyone else come across issues following the 1803 upgrade?