Pivot Table - click through extract data formatting issue

I have a pivot table that is doing something strange. When I double
click a data point in the table, to bring through on a new spreadsheet
the relevant data to to that clicked through data point, all of the
numbers (in every column which contains numbers) on the new worksheet
are formatted as dollars, even though on the original worksheet
containing the data, those numbers are not formatted as dollars, but
rather formatted as general.

The data in the pivot table are not formatted as dollars.
The source data are not formatted as dollars (except for just one
column).
Why would the click through data on the new sheet be formatted as
dollars?
It was not doing this last night, but when I turn on my computer this
morning suddenly it has started doing this.

I tried to fix this myself. I copied the pivot table to a new
workbook. And then inserted a back up of the source data that I had
created a few days before - long before this formatting issue started.
But no the same issue occurs in that workbook too.

Could  there some setting that I am unaware of  that I have
accidentally applied?
0
5/12/2011 12:11:51 AM
excel 39879 articles. 2 followers. Follow

0 Replies
640 Views

Similar Articles

[PageSpeed] 7

Reply:

Similar Artilces:

error in importing data
Sorry the error is 0x8004032d ...

Re: Extracting Exchange User Data From AD 02-24-10
If you do not like scripting, you can try GAL Exporter or Fast User Manager & Reports from IMIBO - http://www.imibo.com > > "Ringholz, Blake" <bringholz@nospam.com> wrote in message > news:76AEFC2F-85A7-4666-8262-27FB0737D09A@microsoft.com... >> Hello All - >> >> I need to get an Excel Spreadsheet that lists everyone first name, last >> name, email address, job title, etc pulled from Active Directory. Is >> there an easy way to do this? >> >> Thanks, >> Blake > > > > > ...

pivot chart #4
Hi, Is it at all possible to make XY type plots from Pivot table data? Yes. At least two come to mind. However, they do require the absence of group (sub)totals in the PT. (1) Create an empty chart by clicking in an empty region of the worksheet. Then, select the PT data, and either copy + select chart and Edit | Paste Special... or just drag the range on to the chart. In the resulting dialog box, specify appropriate settings (probably data in columns, first column contains x values). (2) Create defined names that map on to the appropriate range within the PT. This would incl...

Pivot Table Cycling Through Page Fields Automatically
Hi. I am trying to cycle through a complete set of data in one of the parameters in the "Page" field. For example, there are 500 investments, and I want to compute the internal rate of return (IRR) for each investment based on a series of cashflows for each investment. The IRR is a function that is placed outside the pivot table. As each investment number is chosen, the underlying pivot table cashflow data changes, allow the IRR function to pick up these cashflows and compute the IRR. However, if there are 500 investments, this becomes very time consuming - especially if the...

Issue with Deployment Manager
Dear Friends, After install CRM 1.2, when we try to access Users Administrators in the Deployment Manager, we receive a message, that we can't connect to METABASE Database, errocode 80004005 Has somebody find the same problem? Thank you. Manel Moreno Is crm from the web client working? "Manel Moreno" <mmoreno@watermark-europe.com> wrote in message news:u5OzbYo5DHA.1040@TK2MSFTNGP10.phx.gbl... > Dear Friends, > > After install CRM 1.2, when we try to access Users Administrators in the > Deployment Manager, we receive a message, that we can't connect t...

pivot table #21
I have a question on Excel. When I update a pivot table, I used to be able to hold down the shift and ctrl keys and highlight the area, but lately I found that I cannot use this short cut method. Is there another short cut method? Thanks for your help. In step two of the Pivot Wizard, you should be able to select a starting cell on the worksheet, then hold the Shift key, and tap the End key, then the Down or Right arrow key, to select a range of cells. Or, base the pivot table on a dynamic range, which will expand automatically as new records are added. There are instructions here:...

want to do piovt table, where rows over 100,000
Hi.. i have around 100,000 rows of data... of cousres the worksheet i can only put 66000 or so rows per sheet. i want to do a pivot table that combines the two sheets. how can i do this? thank -- Message posted from http://www.ExcelForum.com Hi if you have that many data I would suggest you store this data in a real database (e.g. MS Access). With Excel's pivot table wizard you can then access this database as datasource. Another way would be to split the data in two worksheets and within the pivot table wizard choose the 'non contigenous ranges' for the data source -- Reg...

Doing Analysis from large amounts of DATA
Hi all, I have an attachment that's apart of this message & within it I have 3 tabs 1) Revenue 2) Expenses & 3) Net Position. I would like to do some Analysis on the above three thou a way where I can manipulate the Data. How would I go about doing this? I've tried a Pivot Table thou it didn�t work out in the sense that it was messy & just failed in calculating stuff, not sure if I did it right thou.. Would really appreciate all the help as I actually have about 20 of these sheets which from that fall into 4 groups being 5 sheets per group. I hope this all makes sense, wo...

lost data when opening excel workbooks ; text import wizard popup
When opening many of my excel files ,which all have the same modification date, I come across the text import wizard which states that my text in these files is 'delimited'. All of the files ,including a few word doc.s have had their data changed to show all " y " with two dots above the letter for as far as the eye can see. No import or export has been done with the files and no modifications were done on that date, as far as I know. Is this a corruption problem or is their some 'fix' that I am overlooking. Thanks for any ideas. ...

transfer inbox in table format to word
In my older version I could cut and paste the table format in Outlook to a word file. Now I don't seem to be able to do it although I can print the file in that format within Outlook. When I export the inbox to word I get the whole text not just the headings. Is it possible to transfer the table format to a word file? ...

Convert Column to row with variable data
Hi I'm using Excel 2k and I have a spreadsheet that looks like this Name Address Fred 21 Blah St London Sue Tower 50 London EC2 and need it to look like this Name Address 1 Address2 Address3 Fred 21 Blah St London Sue Tower 50 London EC2 I have a macro that can convert from column to row but only for a set number of columns. Is there any way to account for the variable amount of data for each address ? Any help much appreciated Thanks David David: I suggest the following formulae - copied down as necessary: C2: =IF(...

Add a specific Record to a Table based on a check box
I have a Table called ServiceTypes. Based on a User's input on a ProposalForm, ServiceTypes need to be added to a ProposalServicesTable. For instance, I have a Check Box on the ProposalForm. When a Check Box is clicked Yes, Access must search the ServiceTypes Table, select a specific ServiceTypeID, and add the ServiceType to the ProposalServicesTable. How can I add the proper Service record from the ServiceTable to the ProposalServicesTable based on the Check Box? I wouldn't do it that way. I'd use a listbox (with multi-select set to YES) that was sourced to the ServiceTab...

pivot table -repeating "months or days" after grouping
I have data that includes the month, day, hour, min. When I run th pivot table function to reduce the data to hourly I need the date t repeat in the date column. Example: 9/19/2002 0:00 2.7 9/19/2002 0:10 3.7 9/19/2002 0:20 3.8 9/19/2002 0:30 4.6 9/19/2002 0:40 4.8 9/19/2002 0:50 4.8 9/19/2002 1:00 5.6 9/19/2002 1:10 5.2 What I get when I group the Pivot table: Sep 19-Sep 12 AM 2.7 - - 1 AM 3.7 - - 2 AM 3.8 - - 3 AM 4.6 - - 4 AM 4.8 What I want is: Sep 19-Sep 12 AM 2.7 - 19-Sep 1 AM 3.7...

Do you need Access to use an Access Database for data entry only?
We have an Access database completed. Now we will use it for reading as well as for data entry. Do we need to install Access for every workstation needing the database for data entry or reading? No you don't necessarily need Access on every computer. You CAN use the Access Runtime and if it is in Access 2007 you can use it for free. If you are using another version then you would need to purchase the developer's edition to be able to legally distribute the associated Access runtime. If you do have 2007 and want to use the runtime, make sure your Full version of Access doe...

Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a pivot table thus displaying a charted image of the detail item selected. Any suggestions? ...

Importing data into Outlook #2
Is there a process or program with which I can transfer my ACT! data into Outlook contacts? Thanks! ...

problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change the text of some sentences of an opened word file, but the problem is when I change the text of a sentence which located before a table, it will be moved to the first cell of the table. My code is as follow: void myMethod( long startingSentenceNumber, const char *toBeSearched, const char *replacement, bool replace ) { Range currentSentenceRange; Selection sentenceSelection; Sentences sentencesList = m_document.GetSentences(); long sentencesCount = sentencesList.GetCount(); CString replacementCStr(...

Question Regarding Excel 2007 Formatting Corruption
Hi Folks, I am having a problem with Excel 2007 files losing all formatting (merged cells, colors, borders, and data formatting (99% turns into 0.99)) when I open a file on our office server make edits and then save the new file on the server. Each sheet usually has a mix of locked and unlocked cells and I unprotect the sheet to make edits. Also, something is fundamentally changed with the file as its size doubles or triples. If I reopen the corrupted file and redo any of the formatting and try to save it none of the new formatting is retained either. Has anyone else ever experienced a pr...

Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to SQL 2000) to ASP.NET(using store procedure in SQL 2000). Finally, I tested them and found that ASP.NET is slower than Access. The mojority job of program is select some data from SQL 2000 tables, modify and then insert into some tables. Is store procedure always fast than Access linked table via ODBC? -- Message posted via http://www.sqlmonster.com Stored procedures don’t add any overhead and they can save compile time. It's the code in the stored procedure and the underlying tables / indexes that ...

Service Pack Installation Issues with GP 9.00.0247.0 on Windows Vi
Greetings, I have installed Great Plains v9.00.0114.0 on Windows Vista. I ran the installation package MicrosoftDynamicsGP-KB923671-v9-ENU, but receive the following messages with result of a failed installation of the Service Pack. Log Name: Application Source: MsiInstaller Date: 10/8/2007 11:50:13 AM Event ID: 11729 Task Category: None Level: Information Keywords: Classic User: ABR\administrator Computer: AD088.abr Description: Product: Microsoft Dynamics GP 9.0 -- Configuration failed. Event Xml: <Event xmlns="http://schemas...

Locks up when clicking on links in open web pages
I don't know if I'm posting this in the correct discussion group, and if not, sorry for the trouble. Could you direct me if I'm wrong? The issue is that the internet connection locks up if I click on a link or attempt to print from within an open website. It does not happen each time, but often enough to make me want to pull my hair! I have to shut down the connection - the message says it is 'not responding,' and reconnect, sometimes 2 or 3 times, to be able to use the link from the website. I have a second laptop, and it doesn't have this problem. ...

Outgoing Mail Issues with Entourage Hotmail Connector
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop Anyone have an issue with Hotmail for Entourage? I can revieve messages but cannot send. I am getting the following error when I try to send a message (of any size, even text only): <br><br>&quot;An operation on the server timed out. The server may be down, overloaded, or there may be too much net traffic.&quot; <br><br>It has been like this for about 3 days. Anyone have an idea? I have checked and tweaked my SMTP security settings, tried multiple internet ...

How do I show a data table with legend keys in a line chart?
I am having trouble inserting a data table with legend keys into a line chart that contains a horizontal target line. Can anyone help me? Hi, I tried it in both 2007 and 2003 and had no problems. We need more infomation, can you post a sample of the chart somewhere. The only issue I have is that the target line is displayed on the data table, which I would prefer that it not be. -- Thanks, Shane Devenshire "excelbanker" wrote: > I am having trouble inserting a data table with legend keys into a line chart > that contains a horizontal target line. Can anyone he...

Output the list of frequent data
Dear all, Here comes two problems. Problem 1: I have a list of strings (say, in the column A1:A100). How can I find the "mode" (i.e. the string appearing most frequently in the list? For example, if the list is APPLE APPLE BANANA APPLE CREAM CREAM BANANA CREAM APPLE DONUT then I want the result is APPLE. It seems that the MODE function does not suppot data type other than numbers. Is there any canned UDF for it? Problem 2: Following Problem 1, I want to generate a list of the 3 most frequent data in the list. If the list is the one in the example, I want to list to be...

Data Validation #47
kshave multiple identacle sheets in a workbook(31 sheets). I am trying to allow users to only enter whole numbers in some of these cells. I know I can do it through Data /Validation/Allow - but, I want to do it on all 31 sheets at once. When I select all sheets - Validation is greyed out. Should I be using a different method? Thanks, Tom Apply the data validation on Sheet1 Copy the cell(s) in which you applied data validation Select Sheet2 Scroll to see sheet31 Hold the Shift key, and click on Sheet31 tab Select the cell where you want to paste the data validation Choose Edit>Paste Cl...