Pivot table changes from 97 to 2000

In Excel 97 on a pivot table you could double click on a 
data cell in the pivot table and a new worksheet would be 
created that contains all the data that was being 
summarized on the pivot table for that particular cell.

When I open a pivot table in 2000 that was created in 97, 
this functionality seems not to exist.

Is there a way to enable this functionality in Excel 2000?

Any assistance will be greatly appreciated.

David Grimsled

0
dgrimsled (1)
3/1/2004 11:09:05 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
319 Views

Similar Articles

[PageSpeed] 57

If you haven't changed any of the settings in the table, it should allow 
  drilling down in Excel 2000, just as it does in Excel 97. To turn the 
feature back on --

Select a cell in the pivot table
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'enable drilldown'
Click OK

David Grimsled wrote:
> In Excel 97 on a pivot table you could double click on a 
> data cell in the pivot table and a new worksheet would be 
> created that contains all the data that was being 
> summarized on the pivot table for that particular cell.
> 
> When I open a pivot table in 2000 that was created in 97, 
> this functionality seems not to exist.
> 
> Is there a way to enable this functionality in Excel 2000?
> 
> Any assistance will be greatly appreciated.
> 
> David Grimsled
> 


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
3/2/2004 3:32:56 AM
Reply:

Similar Artilces:

Bizarre Sales Tax Table Issue
I have four taxes set up in my system, and confirmed in the TAX table in the database: ID Description Rate 1 Sales Tax 0% 2 VAT 15% 3 VAT-EX 0% 4 VAT-ZR 0% If I create a new item, and select VAT, then check the ITEM table, the TaxID = 3 for that item. You would think that the system would apply the VAT-EX taxation on the item. However, when i do a transaction, it puts the 15% rate on the item and everything seems work out okay, including the reports, which show that VAT was collected. The TransactionEntry table has the proper sales ...

count a pair of numbers in row in a table
Hello, my question is: we have the following table: 34 29 13 15 7 15 8 40 11 24 13 6 8 21 38 9 17 23 1 4 22 38 42 37 16 1 18 11 37 41 5 42 18 33 45 9 1 21 41 15 41 1 27 23 42 23 29 7 38 18 42 12 26 34 36 and this one in another sheet 1 2 3 1 2 3 I want to fill the second table with the sum of how many times the numbers if each row and column appear in the same row in the first table. for example: how many time the numbers 2 and 3 appear together in the same row on the first table Nik, Assume t...

i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!! Hi Maybe in the Page Setup you have this setting "fit to1 by 1 page" -- Regards Ron de Bruin http://www.rondebruin.nl "tj" <tj@discussions.microsoft.com> wrote in message news:244325C6-A407-4CD8-BE76-75AB3C93A78A@microsoft.com... >i am trying to make the print on my spreadsheet larger. i can change the > font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!! ...

Add the same field twice to a pivot table but filter one of them?
In my datasheet, I have a "cost" column and a "date" column so each cost has an associated date. In my pivot table, I've added the "cost" as a field, which shows the total and this is fine. However, I'd like to add the "cost" as a field again and this time selecting which dates to include in the cost number so that I have two cost fields side by side. Is something like this possible? Hi That is not possible in the same PT. You will need to set up a second PT based upon the same data set as the first but do NOT use the same Pivot Cache to save ...

Problems with Access 2000 reports in Access 2003
Hi, we have a sent out a 2000 format access database to a client running Access 2003. When trying to open any of the reports they get an error - "the openreport action was cancelled" - Not sure if they get this by running the report from the database window or if it's only when done through a form (buttons that run docmd.openreport when pressed). Is anyone aware of any issues that may be causing this? I couldn't find anything elsewhere on the MS site. Thanks - Angie P.S. the reports work fine in 2000 and XP. ...

mail merge in word 2000
Been trying to link a simple 4 column excel db to do a mail merge in Word. Tried following the help instructions, and finally reached the point where I could "insert a merge field" after realizing they left out a number of steps in the instructions. However, when I do enter the mergefield, the only thing I get is "Error! No bookmark name given." There is no mention of "bookmark" in the instructions, no explanation of what a "bookmark" is in this context, and now way I can figure out what the blasted software is talking about. Anybody go...

Anyway to open a Publisher 2002 file in Publisher 2000?
I need to open this file for a project tomorrow. I have Publisher 2000, but I think the file sent to me was done in Publisher 2002 or 2003? The person who sent it to me is out of town until Thursday, so I can't have them resave it or resend it. Any ideas Thanks! In news:11BBD624-9460-465D-88EE-60230ADB1F33@microsoft.com, buck <create007@yahoo.com> posted: > I need to open this file for a project tomorrow. I have Publisher > 2000, but I think the file sent to me was done in Publisher 2002 or > 2003? The person who sent it to me is out of town until Thursday, so > I ...

Change QuickFind to search contains
Hello, Is there a way to change the QuickFind to use the contains operator rather than begins with? Custom dev or third party recommendations are fine. Thanks. simply put a wildcard * in front of your search term in the query box and it will match the defined search fields for that entitiy type on a 'like" (contains) basis. ...

can comment indicator color be changed?
Hi when you put a comment in a cell the indicator is red but I have cells that are conditionally formatted to come up red if out of spec and can't see the indicator. Can the color be changed and if so how please. Thanks Karl AFAIK, no, you can't change this. Maybe you can change your CF color. Bright yellow? On Wed, 27 Oct 2004 16:27:02 -0700, "Karl" <Karl@discussions.microsoft.com> wrote: >Hi when you put a comment in a cell the indicator is red but I have cells >that are conditionally formatted to come up red if out of spec and can't see >the indic...

Outlook 2003 with Word 2000 Editor
Does anyone know if you can use Word 2000 with Outlood 2003 to edit messages... I couldn't find a download on the web... If you are trying to use, inside of Outlook 2003, Word 2000 as the "editor" ... not possible. Need to use the same "family" together, e.g. Word 2003 with Outlook 2003, or Word 2000 with Outlook 2000. There is nothing to download. Hope this is useful to you. Let us know. rms Brendan Shaw wrote: > Does anyone know if you can use Word 2000 with Outlood > 2003 to edit messages... > > I couldn't find a download on the web... ...

How do I turn the pivot chart into a list with all cells filled?
I have the pivot chart and would like to copy and paste it so that all fields are filled Select the pivot table. Choose Edit>Copy Select the cell where you'd like to paste the copy Choose Edit>Paste Special Select Values, click OK There are instructions here for filling the blanks: http://www.contextures.com/xlDataEntry02.html gianna wrote: > I have the pivot chart and would like to copy and paste it so that all fields > are filled -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

How to remove contacts when email changes
Outlook 2003 If I receive an email from a sender not on my list, that sender's email address is not automatically added to my contacts but will appear on the automated list when I enter the first letter of the sender's email address. If that sender changes email address I cannot delete the old email address. Instead I am left with two email addresses for that sender both of which will appear on the automated list. How can I remove the old email address? You seem to be confused. Receiving an email does not add an address anywhere in Outlook. Sending an email might, a...

Readonly a linked table
I have a table that gets generated every month, and we use as a source of data for other databases. We link this, but I was wondering if there is a way to make that linked table read only. Any ideas? Thanks so much, Chris M. hi Chris, mcescher wrote: > I have a table that gets generated every month, and we use as a source > of data for other databases. We link this, but I was wondering if > there is a way to make that linked table read only. Either make the back-end read-only or use a pass-through query instead of a linked table. mfG --> stefan <-- ...

Best tool for adding a pivot chart like chart to a report?
Is it the PivotChart form or should I used the MSChart OCX? Which is easier to set up/configure to display the data properly? (A multi-column, multi-entity bar chart) Which is the most flexible? And where can I find tutorials on using both? Thanks Kyle Jedrusiak ...

Using tables created in 2003 IN 2007
My office has recently upgraded to 2007. I enjoy new features such as the ability to highlight a few words within the table without the ENTIRE table's font changing; unfortunately, this only works in tables I have created since the upgrade. My old tables that were brought over from 2003 do not have this capability. Is there an add-on out there? I do not have to resort to re-typing and creating all new tables. PS. Copy and pasting into a new table does not work. Convertting the file using the office button does not work. Help? please? I think you talking about what is called...

Totals For a Pivot Table??
I have a pivot table with data linked to an access database. I went to pivot table options and checked the box under the format options area "Grand Totals for columns" so that my colums would have totals at the bottom. When it is on the Title all the way to the far right appears but none of my columns have totals at the bottom?? CAN anybody tell me why?? How can i resolve this, i'm i checking the wrong format box? ...

Placing the results within a table
I have a form where I would add how many openings there are for each position. Once I get the total I can see it on my form but I am not able to transfer that total into my table. My code for this text box is =[VacancyQty1]+[VacancyQty2]+[VacancyQty3]+[VacancyQty4]+[VacancyQty5]+[VacancyQty6] it adds up the number from each of those fields. What I wanna do it to get that sum placed into my table. I have tried [TotalVacancy]=.... "TotalVacancy"=... ="TotalVacancy".... Please help me. I am at a lost. Please and Thank you, Hillary It is not correct to put the total i...

Excel 2007
Hi all, We have a spreadsheet that was set up to link to a database via a system DSN. To simplify deployment of this, I'd like to change this to connect via the connection string below: DRIVER=SQL Server;SERVER=xxx;UID=xxx;PWD=xxx;DATABASE=xxx; I've done this for another spreadsheet, and it was easy (Data tab- >Connections->Properties), but in this next spreadsheet the Connection Properties for one connection are greyed out/disabled, so I can't change the string. Does anyone have any ideas how to enable these values again so I can change the connection string? thanks! ...

Table exist
Hi A simple question On a form, I have a button that create a table when someone click on it "DoCmd.open query " But I want to add something that will stop the code if the table already exist Something like If the table exist then msgbox "The table already exist" else DoCmd.open query "...." So what is the right sentence for "if the table exist" thanks You could use for instance the following function: Public Function tableExists(strTableName As String) As Boolean Dim dbClient As Database Dim tdf As TableDef Set dbClient = CurrentDb For Each...

Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server. My own eMail address is presented to recipients as Aaaaa.Bbbbbb@ccccccc.com Note: mixing of capital and lower letters I want my email address completely changed to lower letters: aaaaa.bbbbbb@ccccccc.com Where in Outlook can I change this? or is this a setting in Exchange Server ? Joe This is a setting in ADUC/Exchange. I would guess that everyone is set up with the same format throughout the company. -- Kathleen Orland - MVP Outlook Outlook Tips: http://www.outlook-tips.net/ http://www.howto-outlook.com/ "Joe deAngelo" wr...

97 to 2003
Converting an Access 97 db to 2003, I got a message "conversion errors encountered - look in conversion errors table". In the table is a single row-- Object Type: Table Object Name: MSysObjects Error Description: -1611: Could not find field 'Description'. This database contains only tables, queries and reports. Any idea what this means? All I can suppose is that some query or report refers to a column called Description in a table that does not contain it. But how to find out which one? David This message probably represents a corruption in the original Access 97 data...

Unable to restore MS Money 2000
My computer crashed, i had to use the recovery cd. Now when i try to load my back up from a floppy, i receive a message that says "unable to restore, can't locate or it might be a read-only attribute." Hoe to i restore? See if you can copy it to the harddrive and restore from there. "Dan" <dan420@optonline.net> wrote in message news:11b3101c383d5$3dcfd810$a601280a@phx.gbl... > My computer crashed, i had to use the recovery cd. > Now when i try to load my back up from a floppy, i receive > a message that says "unable to restore, can't locate ...

Running sql server 2000 and/or sql server 2005 on sbs 2003
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005 and go back to SQL Server 2000. Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog (construction mgmnt software), Great Plains (MS financial), etc. During the install, I kind of just followed directions and installed R2, which I guess installed SQL Server 2005. I wasn't really aware of options. Since then I have had a number ...

How do I refresh the selection listboxes on a pivot table?
The field-level (column) selection boxes used to select the data to be included in a pivot table include old and new values. How do I refresh these list boxes so they only include values that are present in the current source data? The list box continues to show values that are no longer in the data set. Click in the Pivot Table to bring up the Pivot Table toolbar. (If that doesn't bring it up, rt-click a toolbar and select it from the list.) Click the button with the ! icon to Refresh the Pivot Table. Hope this helps |:>) "WWW.CS" wrote: > The field-level (colu...

SQL Table SOP40500 Sales Master Number Setup
Can some rows be deleted from Sql Table SOP40500 to improve performance? Thank You, Brian ...