1

Workbook Image

I need to send the excel workbook tabs from "Combined" to "PPA HQ" that contain pivot tables and graphs, without the source data. Is it possible to do that?

I would like to keep the the tabs "Combined" to "PPA HQ" in the same workbook and same formats, but without the source data.

Any assistance is greatly appreciated!

Improve this question
10
  • I believe you can just select, copy, and paste the data to a new workbook! It will look like a pivot table (because the format will copy) but will not actually be a pivot table. It'll just be a fancily-formatted regular table. Commented Dec 27, 2022 at 19:28
  • Thank you Ann L, it does not copy the graph though. I need to be able keep both pivot table and graph on all the tabs without the source data so I can send to my customers. Commented Dec 27, 2022 at 19:36
  • Is the graph based on the pivot table, or directly on the source data? Commented Dec 27, 2022 at 19:37
  • This is kind of a cheat, but one thing you could do would be do a screen snip of your graph (just the graph and the boundary line) and paste that in as an image. Commented Dec 27, 2022 at 19:38
  • Would it be possible to send your customers a PDF rather than an Excel file, or do they need to be able to interact with the pivoted data (for example, cut and paste it into their own app.)? Commented Dec 27, 2022 at 19:39
Related questions
1
Change Pivot Table Source Data to Excel Table
1
VBA Pivot Table On New Sheet
0
Copy Data from Pivot table to new sheet
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.