pivot table

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I have an excel file created daily which keeps 3 columns
data. What I need is: each time the users open it they
should see data in a pivot table, not as three-columns.
Can I do that? The file is ready only and user does not
have to write it back.
Thanks,
Jim.
 
If you're creating the file programmatically, you could create a pivot
table as part of the process. Hide the sheet that contains the data, and
the users will see only the pivot table when they open the file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Using VBA to create charts 1
Playing back a Pivot Table macros 2
Export Pivot table 1
Access #Error & Excel Pivot 0
modified pivot table using a macro 2
Pivot table multiple filters 2

Back
Top