How can I open an excel file previously made from Excel?

I have all my sport's statistics saved from my old Mac using Microsoft Office 2004. When I purchased my new Retina Display I was under the impression that all my old Excel files could be opened and changed using Numbers. Unfortunately, that is not true because I cannot open any of my basketball stats (73 years worth) using Numbers. I am sure if I could open them, I could then transfer them to Numbers. Can anyone tell me what I can do? Thanks in advance.

iMac, OS X Yosemite (10.10.1), 1TB

Posted on Jul 10, 2015 5:42 PM

Reply
18 replies

Jul 12, 2015 10:21 AM in response to SGIII

LO uses Basic but Visual Basic support is present and improving, Excel (of course) is the VBA king. Numbers is out on a limb with AppleScript (hardly cross platform) But all of this pales beside Numbers hopeless handling of xlsx files, starting with its inability save to the format (an export must be done)


If you live in a vacuum that excludes Excel files then Numbers is a good little home spreadsheet. But still inferior (in functionality) to LO, which is a lot cheaper. Numbers looks good, that's all I can say to commend it.


I have yet to try Excel 2016, I'll get around to it when my current version does not do what I need it to.

Jul 12, 2015 10:44 AM in response to Csound1

Csound1 wrote:


LO uses Basic but Visual Basic support is present and improving, Excel (of course) is the VBA king. Numbers is out on a limb with AppleScript (hardly cross platform)


Actually, Excel for the Mac acted a little strange with some macros from the PC world. Excel 2016 has closed the gap (with the exception of some low-level Windows-specific stuff).


Both VBA and AppleScript are getting long at the tooth, and neither language works very well in the browser or on mobile (which is to say they don't work there at all). But they're both well documented, with tons of examples just an internet search away.


If you live in a vacuum that excludes Excel files then Numbers is a good little home spreadsheet. But still inferior (in functionality) to LO, which is a lot cheaper. Numbers looks good, that's all I can say to commend it.



What is this? Csound1 writing something possibly positive about Numbers! Numbers is just as free as LibreOffice on modern Macs, of course. It's great for home use and some business use, including data entry on mobile in the field. It'll generally exchange data easily with other spreadsheet apps (and other apps that accept spreadsheet data) but it doesn't try to emulate many of the features of other apps. For many users that's a good thing.


SG

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.

How can I open an excel file previously made from Excel?

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