If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I use Goal Seek in a Pivot Table?
I am trying to use Goal Seek in a Pivot Table but Excel won't let me, any
suggestions on how to get it to? Thanks, TJ |
#2
|
|||
|
|||
I'm afraid you're not going to get anywhere with this, although if you post
some information on exactly what you're trying to do (Set Cell? Changing Cell?) it's barely possible that you'll get something useful. The problem is that if you're trying to invoke Goal Seek using a pivot table, there are two possibilities: - You're trying to change a pivot table cell as some other cell changes its value: that is, the Set Cell is in the pivot table. But a Set Cell must be a formula, and a pivot table can't contain formulas (except as a calculated field or item, but they don't show as formulas in the table itself). - You're trying to change some cell outside the pivot table as a cell within the pivot table changes in value. But you can't change a data field value directly, only by changing the table's source and then refreshing the table. And while you can change a row or column item manually, Excel won't let Goal Seek do it. -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "TJ" wrote in message ... I am trying to use Goal Seek in a Pivot Table but Excel won't let me, any suggestions on how to get it to? Thanks, TJ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Data In Pivot Table | John Calder | New Users | 1 | July 7th, 2005 10:41 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |