Solved

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

Posted on 2014-09-18
6
108 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

730 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