Excel save buttons are all greyed out

Joined
Dec 7, 2015
Messages
5
Reaction score
0
Points
1
Hello all,

I recently finished a spreadsheet on Excel and was saving throughout the whole time. However the last save I had was too long ago and I added a lot since that save. When I go to click on the quick save button it is greyed out, and so is the save buttons under the File tab. I haven't tried updating Microsoft Office because that would require restarting the computer. I also tried just exiting out and clicking save when it asks if i want to save the changes, but it just says, "Alert, Document not saved." I really do not want to have to loose my work as it took several hours. Does anyone know a way I can either fix the save problem, or at least export the file somewhere else so I can close and update Office?
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,246
Reaction score
1,834
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
It sounds like the sheet may have become corrupt while you were updating it from the last save. Open Finder and see if you can copy the sheet to another location. If the copy was successful, rename the sheet. Then try opening it and continue. It would also be helpful if you told us which version of Office you're using and which version of OS X you're running.
 
OP
P
Joined
Dec 7, 2015
Messages
5
Reaction score
0
Points
1
It sounds like the sheet may have become corrupt while you were updating it from the last save. Open Finder and see if you can copy the sheet to another location. If the copy was successful, rename the sheet. Then try opening it and continue. It would also be helpful if you told us which version of Office you're using and which version of OS X you're running.

I am running OS x 10.10.5 and Excel 15.13.1. I tried moving and renaming the file but the save buttons are still grey.
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,246
Reaction score
1,834
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
OK, it appears the sheet is corrupt which is why it won't allow saving. It may be that you'll need to start a new sheet see if you can copy and paste to it from the corrupted one. If not, you'll probably need to start over.

Make sure your copy of Office is up to date. Office 2016 has been problematic with both Yosemite and El Capitan which is why you need to install all updates to Office and OS X.


Sent from my iPhone using Mac Forums
 
Joined
Jul 30, 2009
Messages
7,356
Reaction score
341
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
Does Command-S work on the file?
If not, the copy and paste from that file to a new, blank worksheet as suggested above is the way to go.
 
Last edited:
Joined
Nov 1, 2007
Messages
1,298
Reaction score
109
Points
63
Location
Swansea - South Wales
Your Mac's Specs
'24 14"M4Pro MBP 14/20; '23 M2Pro Mac Mini both MacOS 15.1; iPhone 15PM (iOS 18); iPad Air (iPOS 18)
Sorry daft question but have you recently upgraded MS Office?

If you have you'll need to reactivate your instal before you can save anything.
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,246
Reaction score
1,834
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
Sorry daft question but have you recently upgraded MS Office?

If you have you'll need to reactivate your instal before you can save anything.

Good point Nick. I didn't think of that and it appears the OP is using the new Office 2016.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top