Microsoft Excell Mac Incompatibility
Recently, Microsoft upgraded Excel on the Mac to 64-bit, which requires that macros be updated to accommodate 64-bit Excel. This article has details and a link to the developer page having instructions for making your code 64-bit compliant. And each update adds greater compatibility. It’s never been easier to take a Microsoft Office document from your Mac or PC and import it into Pages, Numbers, and Keynote. So you can keep the workflow flowing. See all the ways our productivity apps support popular Microsoft Office features. Word to Pages; Excel to Numbers; PowerPoint to Keynote. Search apple.com. Keynote to work even better with Microsoft Word, Excel, and PowerPoint. Now, more features are supported, including commenting, conditional formatting, and bubble charts. And each update adds greater compatibility. It’s never been easier to take a Microsoft Office document from your Mac or PC and import it into. The application Microsoft Excel quit unexpectedly. Mac OS X and other applications are not affected. Click relaunch to launch the application again. Click report to see more details or send a report to Apple.
Normally part of a series.Intermediate to Advanced.10 minutes.Almost entirely shader tutorials. Videos are always self contained.Beginner to Advanced.30 minutes to 2 hours.Minimal editing. Lots of graphics/shader programming tutorials in addition to 'normal' C# tutorials. Favors theory over implementation but leaves source in video description. Visual studio disable autocomplete. Videos are usually a part of a series.Intermediate to Advanced.Text-based.
The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post.
So I followed the instructions to check all the installed programs on my MacBook Pro and was surprised to find that Microsoft Query will be incompatible. This will affect any Excel for Mac versions you might have on your computer — 2004, 2008, 2011.
I would venture a guess that 99.4% of all Excel users have never used Microsoft Query, but I’m one who does and thought this might be significant to a select few. (Notice that Open XML for Excel and Charts uses PowerPC too.)
Microsoft Query allows you to pull data into an Excel spreadsheet from “behind the wall,” so-to-speak, of a database or ERP system. I made a career out of doing this very thing. Getting data that others could not.
In Microsoft 2010 (Windows) the new PowerPivot can replace Microsoft Query but in Excel for Mac there’s no replacement.
Excel for Mac users should beware, Microsoft Query is an incompatible app in the upcoming Lion upgrade for Mac OS X.
[UPDATE]
Since I wrote this post Microsoft updated their Office 2011 software. If you have Microsoft Office version 14.1.2 or later Microsoft Query has been updated to Intel, as you can see in the screen shot below, instead of PowerPC, and will now work on your Mac with OS X Lion.
Thanks to J. Monroe who pointed out the update by Microsoft in a comment.
Related posts:
We’ve redesigned Pages, Numbers, and Keynote to work even better with Microsoft Word, Excel, and PowerPoint. Now, more features are supported, including commenting, conditional formatting, and bubble charts. And each update adds greater compatibility. It’s never been easier to take a Microsoft Office document from your Mac or PC and import it into Pages, Numbers, and Keynote. So you can keep the workflow flowing.
See all the ways our productivity apps support popular Microsoft Office features.
Ufunc
Microsoft Word Format (.docx) | Pages for Mac | ||
---|---|---|---|
Text | Supported | Partially Supported | Not Supported |
Bidirectional Text | Supported for Arabic and Hebrew | ||
Column Formats | |||
Font Types | Fonts available for download are imported. Unsupported fonts are substituted. | ||
Ligatures | |||
Line Spacing | |||
Subscript | |||
Superscript | |||
Tab Setting | Some tab settings may look different | ||
Text Boxes | |||
Linked Text Boxes | |||
Text Colors | |||
Text Effects | |||
Text Highlighting | |||
Text Wrap | |||
Vertical Text | |||
WordArt | Text is preserved, but formatting may not be maintained | ||
Lists | Supported | Partially Supported | Not Supported |
Image Bulleted Lists | |||
Numbered Lists | |||
Text Bulleted Lists | Stylized bullets replaced with plain bullets | ||
Tiered Numbered Lists | Some lists may look different | ||
Paragraphs | Supported | Partially Supported | Not Supported |
Background Shading | |||
Formatting | |||
Paragraph Styles | |||
Illustrations | Supported | Partially Supported | Not Supported |
ClipArt | |||
Floating Objects | |||
Images | Most image formats are preserved | ||
Shapes | |||
SmartArt Graphics | Imported as shape | ||
Charts | Supported | Partially Supported | Not Supported |
2D Column | |||
2D Stacked Column | |||
2D 100% Stacked Column | |||
2D Bar | |||
2D Stacked Bar | |||
2D 100% Stacked Bar | |||
2D Line | |||
2D Stacked Line | Imported as Line chart | ||
2D Marked Line | |||
2D Stacked Marked Line | |||
2D 100% Stacked Marked Line | |||
2D 100% Stacked Line | Imported as Line chart | ||
2D Area | |||
2D Stacked Area | |||
2D 100% Stacked Area | |||
2D Smooth Marked Scatter | |||
2D Smooth Lined Scatter | |||
2D Straight Marked Scatter | |||
2D Straight Lined Scatter | |||
2D Pie | |||
2D Exploded Pie | |||
2D Pie of Pie | Imported as Pie chart | ||
2D Bar of Pie | Imported as Pie chart | ||
2D Marked Scatter | |||
3D Column | |||
3D Stacked Column | |||
3D 100% Stacked Column | |||
3D Bar | |||
3D Stacked Bar | |||
3D 100% Stacked Bar | |||
3D Line | |||
3D Area | |||
3D Pie | |||
3D Exploded Pie | |||
3D Stacked Area | |||
3D 100% Stacked Area | |||
Bubble Charts | |||
Doughnut | Imported as single tier doughnut chart | ||
Exploded Doughnut | Imported as Pie chart | ||
Surface Charts | |||
Radar Charts | |||
High-Low-Close Stock | Imported as Line chart | ||
Open-High-Low-Close Stock | Imported as Line chart | ||
Volume-High-Low-Close Stock | Imported as Bar chart | ||
Volume-Open-High-Low-Close Stock | Imported as Bar chart | ||
Column Cylinder | |||
Stacked Column Cylinder | |||
100% Stacked Column Cylinder | |||
3D Column Cylinder | |||
Column Cone | Imported as 3D Column Cylinder chart | ||
Stacked Column Cone | Imported as 3D Column Cylinder chart | ||
100% Stacked Column Cone | Imported as 3D Column Cylinder chart | ||
3D Column Cone | Imported as 3D Column Cylinder chart | ||
Column Pyramid | Imported as 3D Rectangle Column chart | ||
Stacked Column Pyramid | Imported as 3D Rectangle Column chart | ||
100% Stacked Column Pyramid | Imported as 3D Rectangle Column chart | ||
3D Column Pyramid | Imported as 3D Rectangle Column chart | ||
Bar Cylinder | |||
Stacked Bar Cylinder | |||
100% Stacked Column Cylinder | |||
Bar Cone | Imported as Bar Cylinder chart | ||
Stacked Bar Cone | Imported as Bar Cylinder chart | ||
100% Stacked Bar Cone | Imported as Bar Cylinder chart | ||
Bar Pyramid | Imported as 3D Rectangle Bar chart | ||
Stacked Bar Pyramid | Imported as 3D Rectangle Bar chart | ||
100% Stacked Bar Pyramid | Imported as 3D Rectangle Bar chart | ||
Header and Footer | Supported | Partially Supported | Not Supported |
Footers | Tables in footers are not supported | ||
Headers | Tables in headers are not supported | ||
Page Numbering | |||
Symbols | Supported | Partially Supported | Not Supported |
Equation | |||
Symbol | |||
Page Setup Options | Supported | Partially Supported | Not Supported |
Borders | |||
Margin Presets | |||
Orientation | |||
Page Sizes | |||
Page Background | Supported | Partially Supported | Not Supported |
Page Color | |||
Watermark | |||
References | Supported | Partially Supported | Not Supported |
Bibliography | EndNote bibliographies are supported. In Word Citation Manager bibliographies, text is preserved but cannot be managed. | ||
Citations | EndNote bibliographies are supported. In Word Citation Manager bibliographies, text is preserved but cannot be managed. | ||
Footnotes | |||
Table of Contents | Not all styling is preserved | ||
Reviewing Tools | Supported | Partially Supported | Not Supported |
Comments | Text comments are supported | ||
Ink Annotations | Imported as shapes | ||
Track Changes | Changes to body text continue to be tracked. All other changes are accepted on import. | ||
Miscellaneous | Supported | Partially Supported | Not Supported |
Breaks | |||
Hyperlinks | Web, email and bookmark hyperlinks are supported. File hyperlinks are removed. | ||
Macros | |||
OLE Objects | |||
Tables | |||
Themes |