Solved

Can't drag fields in Project Web Access Pivot Table report

Posted on 2014-09-18
6
110 Views
Last Modified: 2016-11-23
I am having issues with running the "TimesheetActuals.xls" report from Sharepoint 2013.

I can get the report to open and display data correctly, however we do not have the ability to drag fields between the varioius areas. I can do this with the browser directly on the server (which is IE 10 actually), but cannot with various client desktops around our facility (running IE 11 on new Dell Optiplex 7010...64 bit Windows 7 with 4GB and have also tested on machine with 8GB).
0
Comment
Question by:jb61264
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40367044
not sure if I understood your question correctly.

have a look into this link  http://office.microsoft.com/en-us/excel-help/troubleshoot-pivottable-reports-HP005203507.aspx
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 40450042
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 

Accepted Solution

by:
jb61264 earned 0 total points
ID: 40450039
I found a resolution to this issue on my own after experimenting with Internet Explorer. I found that IE11 is the culprit. Not sure exactly why or how, but as soon as I uninstalled version 11 and installed version 10, the ability to drag fields worked. I reconfirmed this by downloading version 11 again and the ability to drag and drop fields was gone.

Something Microsoft has done to version 11 has removed the ability for the browser to work with Excel pivot tables.
0
 

Author Comment

by:jb61264
ID: 40450043
I found a solution on my own and posted
0
 

Author Closing Comment

by:jb61264
ID: 40460470
There were no other solutions posted that resolved this issue I was having with pivot tables in PWA. I found that if you uninstall version 11 and use version 10, everything works just fine.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question