Level 1

17 points

Unable to open various office docs in sonoma 14.0

Since upgrading to Sonoma 14.0 i have discovered that i am unable to open some documents (Word & Excel). The excel issue seems to be related to documents that opened perfectly in the previous macOS, but now won't. Double clicking on the file in finder has little movement, the icon sort of 'explodes' and then disappears, then nothing (I also have an issue with Finder but will raise another conversation for that). Closing and opening the main excel is OK, but these particular files (.xlsm) will not open. It appears it is only .xlsm files in one specific dropbox folder as other .xlsm files in other folders open OK, with the regular macro warning.

I also now find i cannot open Word docs from some folders. I have a folder with minute documents in that open OK, but go to another folder and try to open a document with no success.

Both Word and Excel do not require any force quitting, however quitting and restarting the apps has no effect on opening the other files.

I stress this has only occurred since i upgraded to Sonoma 14.0 as i was trundling along all happy prior to that, with none of the issues now experienced.

MacBook Pro (2017 – 2020)

Posted on Oct 11, 2023 7:21 PM

25 replies

Dec 21, 2023 8:08 AM in response to Ricky_Charlet

Hmmm, on subsequent testing... This same process did not work for all my files. Only a few. I'm still stuck too.

Only current workaournd I see is to be using the web based office365 apps to edit my onedrive files.

This "feels like" there is some bug between Sonoma and OneDrive. Not clear which side it is on...but Sonoma is the thing that changed.

Jan 20, 2024 3:05 PM in response to RonAbes

I upgraded to Sonoma 14.2 in December, after buying a MacBook Pro 2023, M3.

There are documents I created in Word years ago, on a MacBook Pro 2018, that I can't even locate in my "Documents" folder, since "upgrading" to Sonoma.

Any ideas?

chdsl

Level 2

410 points

Jan 21, 2024 1:25 AM in response to Spanishchick60

Best open your own thread, explaining your own problem to get more attention.

Regarding your old Word documents, if you've saved them in OneDrive you can find them online, and download them manually. Your new MacBook won't connect (sync with) to OneDrive automatically. You have to do that manually, but if you enable automatic sync with OneDrive, you most probably would get unaccounted for lack of storage, heating up, battery drain etc.

chdsl

Level 2

410 points

Nov 16, 2023 12:21 AM in response to Michael002

When did MS Office products became Apple products? Or, the major Apple software?

You use 3rd party apps at your own risk. 😏

Nov 16, 2023 5:18 AM in response to chdsl

🤦‍♂️

chdsl

Level 2

410 points

Nov 16, 2023 5:23 AM in response to Michael002

I have MS Office apps running quite well, for example,

They are still 3rd party apps, made by a 3rd party developer. I use them at my own risk. 😏

chdsl

Level 2

410 points

Dec 18, 2023 4:30 AM in response to hamish186

hamish186 wrote:

Hi chdsl,

I have the same issue - did you find a way round this?

I never had a problem with these apps, only with OneDrive, and with that out of the way no problems. 👌

Dec 18, 2023 4:37 AM in response to chdsl

Ok great. Can you share some tips on how i would go about opening word & excel on my new MB. My old MB still opens them fine. They sit in the dock & one click they’re open & ready to use.

chdsl

Level 2

410 points

Dec 18, 2023 8:21 AM in response to hamish186

Better open your own thread explaining your own specific problem, so someone with a M3 might help you.

chdsl

Level 2

410 points

Dec 19, 2023 8:00 AM in response to dcassius

Glad that you got that problem solved. 👌👍

Best always to keep your Mac updated.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Unable to open various office docs in sonoma 14.0