pivot table
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table

Pivot table

resolvedResolved · Medium Priority · Version 2007

replyReply 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

For upcoming training course dates see: Pricing & availability

replyReply 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

replyReply 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.

 

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard