Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot table

ResolvedVersion 2007

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

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

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.

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.