Can't Open .xls files on my Mac Mini

Discuss the spreadsheet application

Can't Open .xls files on my Mac Mini

Postby monazam61 » Sat Dec 21, 2019 9:27 pm

Hi - strange issue that I'd appreciate some help on - I have a number of files created in OO but saved as .xls and I can't seem to open any of them on my Mac Mini.

I did have an issue with my Mac Mini recently but I saved all the info, restored the drive, reloaded OS Yosemite (10.10.5) but now I can't open those files. I can open ALL and ANY other file so it's a bit odd.

I can open those files on my older Macs, just not on my Mac Mini.

Thanks for any advice in advance.

Mo
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby RoryOF » Sat Dec 21, 2019 9:31 pm

Is there any error message? How do you try to open the files -by clicking on them, or by OO /File /Open?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Can't Open .xls files on my Mac Mini

Postby RoryOF » Sat Dec 21, 2019 9:33 pm

What happens if you make a new file on the Mac Mini, ~(as trivial as you like); Save it. Can you then reopen it?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Can't Open .xls files on my Mac Mini

Postby monazam61 » Sat Dec 21, 2019 9:44 pm

Hi - Thanks for your replies -

1 - I've tried opening them in a number of ways - clicking, by file open, by dragging and dropping them in an open spreadsheet. Nothing seems to work.

2 - I can make a new file but I can't SAVE it as a .xls.

3 - Error message says - Read-Error. Internal Import Error.

Thanks,

Mo
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby RoryOF » Sat Dec 21, 2019 9:52 pm

As a workaround, pending a solution, Save as .ods (best format anyway), and use the free service at http://www.zamzar.com to change to .xls for when (if) you need to share it with others. If you don't need to share and are using OpenOffice on all your computers, why are you using .xls (a foreign format to OpenOffice).
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Can't Open .xls files on my Mac Mini

Postby monazam61 » Sat Dec 21, 2019 10:02 pm

Hi - Yes, I do share with others which is why I use .xls.

I'm going to save the files to a flash drive and open them on my old mac lap top and email them from there. Hopefully others WILL be able to open them in .xls format. It's a temporary workaround until I can find out why they wont open for me.

BT Dubz - I can open them in Preview on my Mac Mini, but of course I can't edit them.

Cheers,

Mo
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby RoryOF » Sat Dec 21, 2019 10:16 pm

All versions of MS Office 2007 and after that date claim to be able to run OpenDocument files (in this case .ods) files, even if their users don't know it.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Can't Open .xls files on my Mac Mini

Postby monazam61 » Sat Dec 21, 2019 10:24 pm

Oh good. I'll suggest that to people and see what happens.

Cheers,

Mo
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby MrProgrammer » Sun Dec 22, 2019 12:17 am

Hi, and welcome to the forum.

monazam61 wrote:Error message says - Read-Error. Internal Import Error.
Search found 28 matches

monazam61 wrote:I can open them in Preview on my Mac Mini, but of course I can't edit them.
Apple's Numbers product claims to be able to open/edit XLS and XLSX files. You should be able to get Numbers free from the App Store.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Mac FAQ Q28/A28
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3953
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Can't Open .xls files on my Mac Mini

Postby monazam61 » Sun Dec 22, 2019 10:32 am

Hi - thanks, I'll give that a go.

Regards,

Mo
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby monazam61 » Mon Dec 23, 2019 11:44 pm

Ok - can't open any files with .xls

Very odd.

M
Open Office 4 on MacOS 10.10.5
monazam61
 
Posts: 6
Joined: Sat Dec 21, 2019 9:23 pm

Re: Can't Open .xls files on my Mac Mini

Postby Villeroy » Mon Dec 23, 2019 11:56 pm

http://forum.openoffice.org/en/forum/do ... p?id=14023 is a valid Excel file. Can you open this with Numbers or with OpenOffice?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27753
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can't Open .xls files on my Mac Mini

Postby John_Ha » Tue Dec 24, 2019 2:46 am

Download both these files and save them to your desktop. Open each file. Make an edit. Save the file.

Describe what happens to each.
Attachments
test.odt
(11.87 KiB) Downloaded 3 times
test.xls
(6.5 KiB) Downloaded 3 times
LO 6.3.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7268
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 7 guests