 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Working with Pivot Tables in a shared workbook
Hi, I have a workbook that has a load of pivot tables in it. When I share the workbook I can't use the pivot tables anymore. Please would someone tell me why, and how do I get around this. I need to be able to share this spreadsheet so that other users can make use of the pivot table I have created. TIA, Jarryd Hi, By the way. I don't need to modify the pivot tables, just change the fields selected in the current report, e.g. this month I have selected June for my report, but next month I want to be able to select July, but the drop downs are inactive. Please help. TIA, Jarryd > Hi, > [quoted text clipped - 7 lines] > > Jarryd You can't change or create a pivot table in a shared workbook, and there's no setting you can change to make it operational. Perhaps you could create the pivot table in a different workbook (non-shared), based on the data in the shared workbook. For more information on shared workbooks, look in Excel's Help, under the topic 'Features that are unavailable in shared workbooks' or view the list at the Microsoft site: Features that are unavailable in shared workbooks http://office.microsoft.com/en-ca/assistance/HP052010801033.aspx > Hi, > [quoted text clipped - 7 lines] > > Jarryd  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Hi Debra, I knew that the Reports couldn't be modified, but I thought you could still use them as Pivot Tables, i.e. that the drop downs would still work so you could change the data displayed. So basically you can't use a pivot table AT ALL in a shared Excel workbook apart form looking at the results as they were at the time of sharing. Is that correct? TIA, Jarryd > You can't change or create a pivot table in a shared workbook, and there's > no setting you can change to make it operational. [quoted text clipped - 20 lines] >> >> Jarryd That's correct. If you could select a different item from a dropdown, that would change the pivot table layout. > Hi Debra, > [quoted text clipped - 32 lines] >>> >>>Jarryd SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.