Access 2007 crashes when creating pivot table.

[joshandsony]

Is anyone else having problems with Access 2007 crashing when creating a pivot table?

I try to create the pivot, and it creates, but it says the details can't be displayed and then it crashes.

Can someone tell me if they have had this problem in the past and how to fix it?

Could it possibly be my if statements within my query?

 

[boblarson]

Now that we know you are running on a Virtual Machine on a Mac, it is completely possible that is your problem. It would be a fairly easy test if you had a regular Windows machine available to test the exact same thing.

 

[joshandsony]

I moved all my info to Windows native and ran all the updates possible, but still getting the error.

I have stopped using the virtual machine because of the other issue.

Would it be better to just create an excel spreadsheet, drop all my data into that and then have the pivot table refresh from the export out of access?

I would like to get away from excel as much as possible, so I can use macros to get all the info I need.

 

[boblarson]

Do this first:

1. Go to the VBA window and go to DEBUG > COMPILE and see if it compiles. If you get any errors, fix those and then do it again.

2. After getting it to compile, and it still has the problem, then try importing all objects into a new, blank ACCDB file.

 

[joshandsony]

I fixed the errors. It is working now.

 

[boblarson]

Glad to hear!