Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-09-18
6
Medium Priority
?
113 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 27

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 49

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

704 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