Solved

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

Posted on 2014-09-18
6
97 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
  • 3
6 Comments
 
LVL 25

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 45

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now