98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table
Pivot table
Resolved · Medium Priority · Version 2007
Tue 3 May 2011, 16:00Delegate Selin said...
Selin has attended:
Excel Advanced course
Project Advanced course
Pivot table
Hi,
I want to create a pivot table but it says 'Reference is not valid'.
What can be the reasons, please?
Thanks
Selin
Tue 3 May 2011, 16:37Trainer Clare said...
RE: Pivot table
Hi Selin,
as we discussed, I believe the problem is the copy/paste from microsoft project into Excel. There are a couple of ways to get the data from one application into the other, but I've redirected this question on to one of our MS Project trainers, Andrew, who will give you more information.
Hope you enjoy the Project course on the 11th.
Clare
Fri 1 Jul 2011, 09:23Trainer Richard said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 7 Jul 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make macros work in newer versions of ExcelIf you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using. |
