T
T2B
I am sent an xls that includes a worksheet that is a pivot table.
There are a couple combo boxes in the first row (e.g., Date, Year)
that if I were able to connect to the external data source would allow
requerying of the pivot table.
I don't need to do that. I just need that data as it is but I would
like to delete the combo boxes from the worksheet. I am prevented
from doing that (msg: you cannot change or modify a pivot table
report).
I can cut the data and paste it into another spreadsheet, however.
I'd rather be able to modify the original worksheet (delete the first
row with the combo boxes). Is this possible?
There are a couple combo boxes in the first row (e.g., Date, Year)
that if I were able to connect to the external data source would allow
requerying of the pivot table.
I don't need to do that. I just need that data as it is but I would
like to delete the combo boxes from the worksheet. I am prevented
from doing that (msg: you cannot change or modify a pivot table
report).
I can cut the data and paste it into another spreadsheet, however.
I'd rather be able to modify the original worksheet (delete the first
row with the combo boxes). Is this possible?