Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx).

Now given that I have installed Compatibility pack, can I create or open a Microsoft Excel 2007 file (.xlsx) having more than 256 columns in Excel 2003? If no, then how can I achieve the same.

My observation: When I open a .xlsx file in Excel 2003 with compatibility, I can't see more than 256 columns (till Column IV).

share|improve this question

migrated from stackoverflow.com Nov 27 '12 at 9:27

This question came from our site for professional and enthusiast programmers.

    
Why are you using a version that is three versions behind? –  SLaks Nov 27 '12 at 4:24
    
@SLaks: Well, not me but client does. You know the licensing issues. We are forced to because the data being generated from the .NET code has more than 256 columns & the client has Office 2003 installed. So I'm looking for a workaround. –  Daredev Nov 27 '12 at 4:29
add comment

1 Answer

You can't do that.
Excel 2003 does not support >256 columns.

The compatibility pack adds support for new file formats, but does not add new features to Office.

share|improve this answer
    
No prob with down vote. But not even with Excel 2007 compatibility pack installed? Atleast, the official Microsoft page doesn't mention any such restriction. –  Daredev Nov 27 '12 at 4:25
    
Atleast you gave your opinion, thanks!!! Can you suggest any alternatives. –  Daredev Nov 27 '12 at 4:44
    
I see 3 solutions: (1) Upgrade Office (2) Use an alternative such as OpenOffice (3) Reduce the number of columns by using multiple sheets instead. –  Craig Nov 27 '12 at 5:17
    
@CraigT: Thanks... but sadly none of them holds. I'll work with another alternative then. :) –  Daredev Nov 27 '12 at 5:31
3  
Once, a while ago, when faced with a similar issue, I flipped columns and rows, since at that point my rows << columns.. –  Karthik T Nov 27 '12 at 9:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.