Help with BLANK in Pivot slicer

[mdazuk]

Hi

I require some help.
I have a Pivot slicer that controls some charts. However the Slicer as a BLANK in it.
I know this is caused due a column within the Data source containing a formula in every cell.
There is data in the first few rows that creates the slicer, the rest of the rows are left blank for future input and the formula's run down the column ready to calculate the data of the new input.

Is there away round this?

 

[shift-del]

Hi

You do not need formulas on stock.
Delete the "blank" rows. Change your source data to an Excel tabel (CTRL-T). Rename your table appropriately. Change the data source in the pivot table to the newly created table.
Formulas and formatting will automatically copy down when you add new data to your source. However that requires unique formulas in your columns.