cells outside the boundaries of iWork

Hello

I will open a Excel document in Numbers,

but I get a error message

cells outside the boundaries of iWork tables have been removed

so I can not see the total document in Numbers,

Please can someone advise me how I get the full document in Numbers.


Thank you

iMac, macOS High Sierra (10.13.3)

Posted on Mar 23, 2018 5:44 AM

Question marked as Top-ranking reply

Posted on Mar 23, 2018 7:16 AM

How many columns are there in your Excel sheet? Numbers isn't designed for large data sets and can only handle 200+ columns.


If your Excel sheet is very "wide" but not too "tall" you could try transposing it so it is taller than it is wide (Edit > Paste Special and click the 'Transpose' checkbox). Then try opening it with Numbers.


SG

3 replies
Question marked as Top-ranking reply

Mar 23, 2018 7:16 AM in response to Community User

How many columns are there in your Excel sheet? Numbers isn't designed for large data sets and can only handle 200+ columns.


If your Excel sheet is very "wide" but not too "tall" you could try transposing it so it is taller than it is wide (Edit > Paste Special and click the 'Transpose' checkbox). Then try opening it with Numbers.


SG

Mar 23, 2018 10:10 AM in response to Community User

Hi T'


(In essence, what's already been said by SGIII.)


"cells outside the boundaries of iWork tables have been removed"


The message means exactly what it says. Your Excel table is too large to fit into a Numbers table.


Reduce the number of (active) columns in the Excel document to 255 or fewer.*

Reduce the number of (active) rows in the Excel document to 16 300 or fewer.**


Then try importing to Numbers.


You could also try splitting (a copy of) your Excel document into two "worksheets". I have not tested that process, hence the advice to try it with a copy of your doc.


Regards,

Barry


**Actual number of possible rows is rounded down to nearest 100.

*Both of these are absolute maximums for the number of columns and rows. Practical limits are much lower, and Numbers will slow down appreciable long before these limits are reached.

B

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.

cells outside the boundaries of iWork

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