I am working through Que’s “Using Microsoft Access 200, Special Edition”, in the section in Chapter 20 on using the Pivot Table Wizard. I followed the steps for creating a query, then a new form using the Wizard, but when I get near the end, and the last dialog is displayed with a newly opened Excel workbook, I click the Layuot button as directed and get the message “Prolbems obtaining data”, and can get no further.
Microsoft has a Knowledge Base article on this message, but it only relates to parameter queries, and my query has no parameters. I’ve also found indications on the Web that a lot of of other people have also run into this problem, with Access 97 – 2003 … but no solutions.
Does anybody know what’s going on here?
