Program stops (creating pivot table) when too many records
 

Hi all,

I have a macro which creates a Pivot Table using the records I provide and
it works fine up to probably 40,000 records.

When the database becomes too big, the program stops at the line of code
which creates the Pivot Table with an error message.
1) Pressing F5 simply gives the same error message.
2) Running the same macro from start with a reduced records works well again.

How can I overcome this problem?

Thanks in advance.

Program stops (creating pivot table) when too many records
 

On Mar 5, 7:57*am, ch wrote:
Hi all,

I have a macro which creates a Pivot Table using the records I provide and
it works fine up to probably 40,000 records. *

When the database becomes too big, the program stops at the line of code
which creates the Pivot Table with an error message.
1) Pressing F5 simply gives the same error message.
2) Running the same macro from start with a reduced records works well again.

How can I overcome this problem? *

Thanks in advance.

Are the variables declared have sufficient range?