Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Problems opening Excel 2003 files after Windows 10 update

  1. #1
    Board Regular
    Join Date
    May 2007
    Location
    Lincolnshire, England
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Problems opening Excel 2003 files after Windows 10 update

    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

    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?
    Dave

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    10,392
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    I don't have a solution for you, but I will leave a comment. I also liked the simplicity of the xl2003 version. I had vba procedures stored in a file from my days before retirement, which contained some complex data manipultions among different applications, workbooks and sheets. These were programs as apposed to macros. I ended up abandoning those files because it wouold have taken a complete rewrite for them to work and since I no longer have access to some of the databases, it would be an exercise in futility to do a re-write. However, I still refer to some of the procedures from time to time for method when I am stuck on a project. So they do still have value, although they will not run without anomally.

    I think that the software people at MS are ignoring the older versions when the "enhance" the newer versions of Office applications, especially in Excel. Yes, there are more bells and whistles in the newer version, but there hasn't been a big change in the basics or how users apply the tools that are available.
    Last edited by JLGWhiz; May 26th, 2018 at 11:53 AM.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  3. #3
    Board Regular
    Join Date
    Feb 2012
    Location
    Japan
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    A report that Excel 2003 crashes by Windows 10 (1803 update) is posted on forums around the world.
    https://www.google.com/search?q=Wind...1803+Excel2003

  4. #4
    Board Regular
    Join Date
    May 2007
    Location
    Lincolnshire, England
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    Quote Originally Posted by JLGWhiz View Post
    I don't have a solution for you, but I will leave a comment. I also liked the simplicity of the xl2003 version. I had vba procedures stored in a file from my days before retirement, which contained some complex data manipultions among different applications, workbooks and sheets. These were programs as apposed to macros. I ended up abandoning those files because it wouold have taken a complete rewrite for them to work and since I no longer have access to some of the databases, it would be an exercise in futility to do a re-write. However, I still refer to some of the procedures from time to time for method when I am stuck on a project. So they do still have value, although they will not run without anomally.

    I think that the software people at MS are ignoring the older versions when the "enhance" the newer versions of Office applications, especially in Excel. Yes, there are more bells and whistles in the newer version, but there hasn't been a big change in the basics or how users apply the tools that are available.
    When you are used to something and don't want/need to change, it's galling to be forced to! Like yourself, I have many Workbooks with lots of code in, which just work. I don't need 2007!
    Dave

  5. #5
    Board Regular
    Join Date
    May 2007
    Location
    Lincolnshire, England
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    Quote Originally Posted by AddinBox_Tsunoda View Post
    A report that Excel 2003 crashes by Windows 10 (1803 update) is posted on forums around the world.
    https://www.google.com/search?q=Wind...1803+Excel2003
    Spotted some of these after posting

    The Workbooks I thought were working on my own laptop, aren't! Enter text, no problem, enter numbers - Excel vanishes!

    Searching for a solution. If I can't find one, I'll have to revert to my previous version of W10. Just wish you could stop the updates...
    Dave

  6. #6
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    10,392
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    Quote Originally Posted by cedricthecat View Post
    Spotted some of these after posting

    The Workbooks I thought were working on my own laptop, aren't! Enter text, no problem, enter numbers - Excel vanishes!

    Searching for a solution. If I can't find one, I'll have to revert to my previous version of W10. Just wish you could stop the updates...
    I believe there is a system setting for the user to block updates by requiring approval before they can process. Don't remember exactly where it is, but it must be in control panel somewhere. The thing is that most of the updates are security updates and if you don't allow them, you are subjecting your system to infiltration of viruses and malware.
    Last edited by JLGWhiz; May 26th, 2018 at 09:17 PM.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  7. #7
    Board Regular
    Join Date
    May 2007
    Location
    Lincolnshire, England
    Posts
    460
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problems opening Excel 2003 files after Windows 10 update

    Quote Originally Posted by JLGWhiz View Post
    I believe there is a system setting for the user to block updates by requiring approval before they can process. Don't remember exactly where it is, but it must be in control panel somewhere. The thing is that most of the updates are security updates and if you don't allow them, you are subjecting your system to infiltration of viruses and malware.
    Yes, you are right with this

    Briefly, this got much worse before it got better. I tried setting Excel 2003 to open in Compatibility Mode, and this gave me "Could not load" errors, followed by allowing files to load, but only after stripping all the VBA from them!

    After this, I decided to roll back the update, in the hope I'd be able to defer it until it's had these Excel/Office issues fixed. I expected the update to take the same 2-3 hours to uninstall as it had taken to install, but actually it was only half an hour max. I also expected this not to have worked with the Excel issue, but it did!

    More research on updates suggests there should be a "snooze" option when the banner appears to tell you it's going to happen, and that you can defer up to 180 days. Mine didn't have this, but a kind of work-around is supposed to exist, in setting your connection to "metered" which purportedly puts you, the user, back in control of update downloads. We shall see! In the meantime, Excel works, which is a relief!
    Dave

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •