Can you create a pivot table using tables from different workbooks?
You cannot protect cells from not being printed.
Imported from external platform