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.

Microsoft Excell Mac Incompatibility

See all the ways our productivity apps support popular Microsoft Office features.

Excell

Ufunc

Microsoft Word Format (.docx)Pages for Mac
TextSupportedPartially SupportedNot Supported
Bidirectional TextSupported for Arabic and Hebrew
Column Formats
Font TypesFonts available for download are imported. Unsupported fonts are substituted.
Ligatures
Line Spacing
Subscript
Superscript
Tab SettingSome tab settings may look different
Text Boxes
Linked Text Boxes
Text Colors
Text Effects
Text Highlighting
Text Wrap
Vertical Text
WordArtText is preserved, but formatting may not be maintained
ListsSupportedPartially SupportedNot Supported
Image Bulleted Lists
Numbered Lists
Text Bulleted ListsStylized bullets replaced with plain bullets
Tiered Numbered ListsSome lists may look different
ParagraphsSupportedPartially SupportedNot Supported
Background Shading
Formatting
Paragraph Styles
IllustrationsSupportedPartially SupportedNot Supported
ClipArt
Floating Objects
ImagesMost image formats are preserved
Shapes
SmartArt GraphicsImported as shape
ChartsSupportedPartially SupportedNot Supported
2D Column
2D Stacked Column
2D 100% Stacked Column
2D Bar
2D Stacked Bar
2D 100% Stacked Bar
2D Line
2D Stacked LineImported as Line chart
2D Marked Line
2D Stacked Marked Line
2D 100% Stacked Marked Line
2D 100% Stacked LineImported 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 PieImported as Pie chart
2D Bar of PieImported 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
DoughnutImported as single tier doughnut chart
Exploded DoughnutImported as Pie chart
Surface Charts
Radar Charts
High-Low-Close StockImported as Line chart
Open-High-Low-Close StockImported as Line chart
Volume-High-Low-Close StockImported as Bar chart
Volume-Open-High-Low-Close StockImported as Bar chart
Column Cylinder
Stacked Column Cylinder
100% Stacked Column Cylinder
3D Column Cylinder
Column ConeImported as 3D Column Cylinder chart
Stacked Column ConeImported as 3D Column Cylinder chart
100% Stacked Column ConeImported as 3D Column Cylinder chart
3D Column ConeImported as 3D Column Cylinder chart
Column PyramidImported as 3D Rectangle Column chart
Stacked Column PyramidImported as 3D Rectangle Column chart
100% Stacked Column PyramidImported as 3D Rectangle Column chart
3D Column PyramidImported as 3D Rectangle Column chart
Bar Cylinder
Stacked Bar Cylinder
100% Stacked Column Cylinder
Bar ConeImported as Bar Cylinder chart
Stacked Bar ConeImported as Bar Cylinder chart
100% Stacked Bar ConeImported as Bar Cylinder chart
Bar PyramidImported as 3D Rectangle Bar chart
Stacked Bar PyramidImported as 3D Rectangle Bar chart
100% Stacked Bar PyramidImported as 3D Rectangle Bar chart
Header and FooterSupportedPartially SupportedNot Supported
FootersTables in footers are not supported
HeadersTables in headers are not supported
Page Numbering
SymbolsSupportedPartially SupportedNot Supported
Equation
Symbol
Page Setup OptionsSupportedPartially SupportedNot Supported
Borders
Margin Presets
Orientation
Page Sizes
Page BackgroundSupportedPartially SupportedNot Supported
Page Color
Watermark
ReferencesSupportedPartially SupportedNot Supported
BibliographyEndNote bibliographies are supported. In Word Citation Manager bibliographies, text is preserved but cannot be managed.
CitationsEndNote bibliographies are supported. In Word Citation Manager bibliographies, text is preserved but cannot be managed.
Footnotes
Table of ContentsNot all styling is preserved
Reviewing ToolsSupportedPartially SupportedNot Supported
CommentsText comments are supported
Ink AnnotationsImported as shapes
Track ChangesChanges to body text continue to be tracked. All other changes are accepted on import.
MiscellaneousSupportedPartially SupportedNot Supported
Breaks
HyperlinksWeb, email and bookmark hyperlinks are supported. File hyperlinks are removed.
Macros
OLE Objects
Tables
Themes
Comments are closed.