Error on Import saying max amount exceeded ?

rowedf

New Member
Joined
Oct 13, 2011
Messages
36
I saw in the videos that rows got into the 7million range, but I have a table that has slightly over 700k of rows and it's giving me the maximum amount error when I try to import. It's saying:

A value in column 'hidden column name' of table '69ab3898-b3aa-466c-a71d-bb4d5606ef8e' exceeded the maximum allowable size.

Any ideas? Thanks.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

powerpivotpro

Board Regular
Joined
Jan 18, 2012
Messages
242
This might actually be a bug. I do remember seeing something similar a long time ago. What version of PowerPivot are you running?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,740
Messages
5,524,557
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top