Hi,

I need to change the data range for a pivot tables in excel 2007. In 2003 there was the option to do so in the wizard but I cant find that option in 2007. Any clues?

Thanks

__________________
- Portuga

There is no such thing as a problem, only a temporary lack of a solution


In formulas,you might need to replace ; with , depending on your XL version

G'day Portuga,

Where you been ?

To change the Data Source, click inside the pivot table.

Then look at the top of the ribbon (right hand side) and I'll see extra tab appear named 'Options' and 'Design'.

Under the 'Options' tab, there a button named 'Change Data Source'.

The rest speaks for itself.

HTH

__________________

Office 2007
Any Feedback Welcomed

If you receive a solution....Please let us know:

1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button

Note: If it's more than 2 days after your first post, please ask a moderator to mark the thread SOLVED for you.

Hi Ratcat thanks for the help, its what I was looking for. Still trying to figure out the 2007 menus...

Yes, I´ve been out of action for a while and the tendency is to continue.
Decided to leave the busines analysis business and dedicate myself full time to skydiving. Now instead of a computer for a living, I throw myself from a perfectly working plane with my tandem passengers and I also teach some students.

Just do some random, part-time, excel automation work,so I dont miss it too much

Thanks again

__________________
- Portuga

There is no such thing as a problem, only a temporary lack of a solution


In formulas,you might need to replace ; with , depending on your XL version

Now worries Portuga !

Good luck in your new profession.

All I can say now went the plane does have problem you'll know what to do. lol

__________________

Office 2007
Any Feedback Welcomed

If you receive a solution....Please let us know:

1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button

Note: If it's more than 2 days after your first post, please ask a moderator to mark the thread SOLVED for you.