Cannot open excel file

Good Day


I have a .excel file saved to my MacBook and I have opened it in an attempt to edit and save a duplicate as I am just modifying dates and activities. When I attempt to 'save as' I am notified that I do not have permission to save to this location (despite the location). I then duplicated the document manually and made an edit and then got the same message. I then proceeded to open the original and got the message 'Sorry, we couldn’t find /Users/joshuavanniekerk/Library/Mobile Documents/com~apple~CloudDocs/'. I am not sure exactly what is going on as I have been able to use this method on multiple other .excel files and make duplicates or edits and then 'save as' to create a new modified version. I have tried moving the file to a new location or to my homepage, but the issue persists. I now cannot edit the original document and I cannot make another as the format I designed is very time consuming and specific. I know this is a Mac issue as I do not have this same issue with my windows PC.


MacBook Air (M1, 2020)

Posted on May 9, 2023 03:09 PM

Reply
Question marked as Top-ranking reply

Posted on May 9, 2023 03:31 PM

I figured out the solution. The file names contained dates and the date format used was 15/02/2023. The file being searched for was 15:02:2023. The Mac does not recognise forward slash (/) as a path name and therefore could not find the location of the file or would not allow a save which contained these symbols either. Simply editing the name by adding a colon (:) or adding dash (-) between each number has resolved the issue.


Thanks for the Help.

Similar questions

2 replies
Question marked as Top-ranking reply

May 9, 2023 03:31 PM in response to BigBananaJosh

I figured out the solution. The file names contained dates and the date format used was 15/02/2023. The file being searched for was 15:02:2023. The Mac does not recognise forward slash (/) as a path name and therefore could not find the location of the file or would not allow a save which contained these symbols either. Simply editing the name by adding a colon (:) or adding dash (-) between each number has resolved the issue.


Thanks for the Help.

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.

Cannot open excel file

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.