Error Transferring data from Access 2007 to Excel 2007 pivot table

[bkande2]

I have a database in Access which I am trying to import into an Excel pivot table. I have been successful in the past with that task from Excel by inserting a pivot table from an external data source.

I currently have a pivot table linked to Access, and I made changes in the Access database, so I want to update my pivot table in Excel. However, any time I hit "refresh", Excel tries to refresh for a minute and then gives me the error: Error 3163: The field is too small to accept the amount of data you're trying to add

I've trying looking up this error in other forums, but it only comes up with other people in their code. Therefore, they're able to trace the error to a column or row size. I am not using any code here, just trying to update. So I have no idea how to identify the source of the problem or how to fix it. I've tried creating a new pivot table from the same Access query (instead of updating) and I am getting the same error message as a result.

Any advice?

 

[bkande2]

Is there any one who can help me with my above question? It's very important

 

[bkande2]

I was able to solve my own problem. I was linking an Excel file to Access, then combining an access table with the linked Excel table to create the query, which I was then feeding into an Excel Pivot table.
The problem was I had some merged cells in the original linked Excel spreadsheet that was causing the error to come up whenever I wanted to update the pivot table. When I unmerged the cells, my problem went away!