ExcelBanter - use dynamic data source to make pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - use dynamic data source to make pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/194892-use-dynamic-data-source-make-pivot-table.html)

Henry

use dynamic data source to make pivot table

http://www.contextures.com/xlPivot01.html

I tried several times following the instructions but in the
last step€”creating a pivot table, after I have typed in the name I had
defined for the database, excel always told me: Reference is not valid.
Thanks

All times are GMT +1. The time now is 02:59 AM.