Visual Basic error in PivotTable wizard

  • Thread starter Thread starter K Watkins
  • Start date Start date
K

K Watkins

When I try to use the PivotTable Wizard in Access,
everything seems to go well through the selection of
fields, and a minimized window with a generic Form caption
even appears briefly. But then I get the error
message, "The class argument in the CreateObject function
of the Visual Basic procedure you're trying to run is
invalid." This happens even if I select only two fields
(primary key, text, date, Y/N...this database doesn't
include numerics).

This is my first attempt at a PivotTable, and I don't know
Visual Basic, so this error message is opaque to me. I
can't find this problem in the Knowledge Base. I'm
running Access 2000 and Excel 2000 on a Windows 2000
system.

What do I need to do in order to get a PivotTable rather
than this error message?
 
In case anyone else has been watching this question:
I found the answer in the Knowledge Base eventually
(thank you, Google!), at
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;315454. This problem 'can occur if incorrect NTFS
permissions are defined for your "%ProgramFiles%\Common
Files\System" folder.' Go to the URL for instructions on
how to fix them.
 
Back
Top