ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No data for pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/197450-no-data-pivot-table.html)

dchristo

No data for pivot table
 
We have an access database that exports data to a pivot table daily,
sometimes there is not data to export. When that happens, we get a message
when opening the pivot table "This command requires at least tow rows of
source data. Your cannot use the command on a selection in only row". How
can we circumvent this message and add another that states "These is no data
to report"

Thanks


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com