Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2021, 07:17 PM
jasonbrod jasonbrod is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2016
Novice
Recent Office Update causing issues opening older Excel worksheet
 
Join Date: Dec 2021
Posts: 3
jasonbrod is on a distinguished road
Default Recent Office Update causing issues opening older Excel worksheet

My Excel was recently updated and now when i try to open a worksheet in the Excel 97 format which contains MACRO's it will not open. It was not saved as a macro enabled worksheet.



What do I need to change in the new properties in order to open this worksheet?

I last was able to last get into it on 11/18 and in the time, my Excel has been updated.
Reply With Quote
  #2  
Old 12-17-2021, 03:05 AM
wiganken wiganken is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Have you looked at: -


Change macro security settings in Excel
Reply With Quote
  #3  
Old 12-17-2021, 07:14 AM
jasonbrod jasonbrod is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2016
Novice
Recent Office Update causing issues opening older Excel worksheet
 
Join Date: Dec 2021
Posts: 3
jasonbrod is on a distinguished road
Default

I have gone through most of those security settings and nothing seems to work unless I am clicking the wrong ones.
Reply With Quote
  #4  
Old 12-17-2021, 08:35 AM
wiganken wiganken is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Maybe security software is blocking you opening documents it now considers insecure?
Reply With Quote
  #5  
Old 12-17-2021, 08:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Recent Office Update causing issues opening older Excel worksheet Windows 7 64bit Recent Office Update causing issues opening older Excel worksheet Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Have a look at Use Excel with earlier versions of Excel
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 12-17-2021, 11:06 AM
jasonbrod jasonbrod is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2016
Novice
Recent Office Update causing issues opening older Excel worksheet
 
Join Date: Dec 2021
Posts: 3
jasonbrod is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
I would do this if Excel let me open the file. Each time I try to open the file, it crashes Excel.
Reply With Quote
  #7  
Old 12-17-2021, 03:43 PM
rollis13's Avatar
rollis13 rollis13 is offline Recent Office Update causing issues opening older Excel worksheet Windows 10 Recent Office Update causing issues opening older Excel worksheet Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Hi to all.
Start your file in Safe Mode (hold down the Ctrl key while launching it); this will not activate the macro it contains.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
windows 7/office 2016's recent major update problem moon84 Office 0 01-10-2020 04:13 AM
Office 2007 "Remnant" Causing Update Failure? RP McIntosh Office 0 01-30-2019 06:30 PM
Unable to select text using mouse after recent Office 365 update TechDiva95 Word 2 10-16-2018 05:19 PM
Recent Office Update causing issues opening older Excel worksheet Older Office compatibility issues...help michaelpat87 Office 1 06-24-2011 09:39 PM
Issues with synchronization log causing send/receive issues WinSock64 Outlook 0 01-11-2011 11:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft