pivot table
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. |
pivot table
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. JIM.H. wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com