format changes on pivot table although preserve formatting is che.


        
0
Aannd (2)
4/20/2005 10:59:01 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
128 Views

Similar Articles

[PageSpeed] 1

Post the question the body of the message, subject lines get truncated

-- 
Regards,

Peo Sjoblom


"Aannd" <Aannd@discussions.microsoft.com> wrote in message 
news:282F34F1-42CA-4F0A-8A62-A71C64E30741@microsoft.com...
> 


0
terre081 (3244)
4/20/2005 2:02:11 PM
Reply:

Similar Artilces:

Change entries in popup list for partially typed email addresses
When I start a new email and type in the first few letters of a recipient name or email address, I am given a helpful list of candidate addresses. However, the email addresses of one acquaintance in this list needs to be corrected. How can I do this? I tried looking in the address book, but none of the lists seem to contain this contact. I am using Outlook 2003 on Windows XP. The autocompletion cache has nothing to do with your Contacts. It is simply a cache of your prior recipients. Remove individual addresses from the autocompletion cache by highlighting the entry when pres...

pivot table #6
I have been tasked with putting together a pivot table for my group that will highlight if a persons vacation falls within blackout dates. Right now I have a list of names and a start and end date for there vacations. I also have a list of blackout dates set up with start and end dates. Not sure about where to start or if this can be done? Below is what I have so far Tab 1 A B C 1 John Doe 10/1/08 10/8/08 2 Jane Doe 1/2/08 1/9/08 Tab 2 A B C 1 blackout A 1/7/08 1/20/08 2 blackout B 9/28/08 ...

How do I make into a dollar format when in a formula?
"We have been asked to contact you by our client 0, regarding your past due invoice for 7896.98. Their records indicate that payment has not been received as of the date of this correspondence, and is therefore listed for collection. This balance may include finance charges. " How do I make the 7897.98 w/ a dollar amount? The current formula is " & c8 & ". Please HELP!!! Hi krissy, > How do I make the 7897.98 w/ a dollar amount? The current formula is " & > c8 > & ". =TEXT(C8,"$0.00") Ed Ferrero...

Data analysis by 2-dimensional data table + database
Hello, in an old Excel-manual (possibly way back to version 3) by Microsoft there was an excellent example of a 2-dimensional datatable (in German: Mehrfachoperation) with input variables based on database results. Now I would need to apply this technique, but my old manual is lost, and I can't figure out by heart exactly how this was done. Does somebody still have an old manual from which to draw the model, or can let me know the deatils of the trick? Thank you in advance. Kind regards, H.G. Lamy H., I think that you are talking about a cross-tab table....

i need to format a column as microseconds ? how do i do this
i need to format a column as microseconds ? how do i do this eg : hh:mm:ss.___ Format>Cells>Custom In the Type box, enter hh:mm:ss.000 -- Kind Regards, Niek Otten Microsoft MVP - Excel "SMT" <SMT@discussions.microsoft.com> wrote in message news:CF0BAF0B-FEC9-46CD-9784-3FDBEBA6729F@microsoft.com... >i need to format a column as microseconds ? how do i do this > eg : hh:mm:ss.___ ...

changing tcp port used by exchange 5.5?
Hello, We are trying to find out if it is possible to change the tcp port that exchange 5.5 uses to send outgoing (internet bound) emails? specifically, we are trying to have our internal exchange 5.5 server send all outbound emails to our unix based/postfix server using a port other then 25. I have search both technet and google but seem to only find articles relating to inbound or client based issues. can you point me in the right direction/tech article? I have to admit I don't know if this applies to 5.5, but maybe it'll help if it's somewhat similar. This is how it'...

how to change range for dynamic chart in excel 2000 with button?
i need a help please. i have problem in excel chart. i add data to the table. and then if i want to update my chart i need to change the range too, isn't it? is there any solution for that? i've already use dynamic chart. but it always show data from Jan04 till Jan05. If I add Feb05 it will change from Feb04 to Feb05. what about if i want to see Dec03 till Dec04? is there any command or something else like using macro or vb? thank you in advance.. ivan Ivan, You should be able to set the dynamic chart to show just about any range you want. These articles should help: http://pu...

Changing English text to Spanish text
Hello can anyone help me out with this... I'm creating a newsletter, and want to see if there is a way to convert the english text to spanish... Any help would be great.. Thank you Gilbert Saenz sagi300@dshs.wa.gov There are translation services available for a cost. "Gilbert Saenz" <anonymous@discussions.microsoft.com> wrote in message news:184001c3fbd5$f566d9b0$a001280a@phx.gbl... > Hello can anyone help me out with this... I'm creating a > newsletter, and want to see if there is a way to convert > the english text to spanish... Any help would be great.....

Excel Formatting #3
I want to know how to format rows into even columns. For example, my spreadsheet has 160 rows that I would like to format into 3 even columns across a landscape page. Can anyone tell me how this is done? ...

Excell
How do I change font colour in a footer?? There are options to change the font, size, underline etc but not colour... Can anyone help? You can't change the font colour in a footer. If you really need coloured text, you could print just the footer using Word, then print the Excel file onto those pages. Or, if you have Excel 2002, you can insert a coloured picture into the footer, so you could create a graphic with the text, and insert that. cinabar wrote: > How do I change font colour in a footer?? > > There are options to change the font, size, underline etc > but not...

Format for 1st and 3rd Tuesday of each month?
Ok experts, I have a cell that takes todays date from A1, subtracts A2 to end up on a new date, but I need the new date to be the first or third Tuesday of a month. And, it needs to round it to the Tuesday that is not past the true sum date, i.e., higher. Example TODAYS DATE = 5/26/04 A2 = 10 That would equal 5/16/04, a Sunday. Though it is closer to Tuesday the 18th, I need it to round to Tuesday the 4th. Thanks. try the first one =DATE(YEAR(A1),MONTH(A1),1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)-3)+7 or =DATE(YEAR(TODAY()),MONTH(TODAY()),1)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY ()),1)-...

"IF" statement in a pivot table.
I need help in writing a "IF" statement in a pivot table. My data consists of sale orders numbers that may have several line items - I am trying to do a count on the sale orders and Excel count each item as a separate sales order. Is it possible to write a "IF" statement in a pivot table? Does anyone have any suggestions as to how I should approach this? Elizabeth If you have an order # them leave out the items and then simply set the order # to 'count'. You will not be able to count the unique orders in the table with the items in (AFAIK), as Excel will ...

table relationship in query
Hello, Should it be table relationship in query the same as the relationship of table when we first designed it? I asked this because I have a problem in membership table I have pathid, so this could be many, while in the Imagetable I will have also many member number, So is it many to many. I am confused on this Thanks for any idea provided -- H. Frank Situmorang "Frank Situmorang" <hfsitumo2001@yahoo.com> wrote in message news:7C9CB908-4535-428E-A37B-448D083064A8@microsoft.com... > Hello, > > Should it be table relationship in query the same as the relations...

Updating a table with a field extracted from a join
Okay, here's a fun SQL question that's got me stumped, but it takes a bit to explain. I want to update a table with a value extracted from a join of two others. The three tables are Music (a list of sheet music), Concerts (a list of concerts) and SongPerformances (a list of the individual songs performed at each concert). I want to update Music.LastPerformedSeason across the board with the season of the most recent concert at which that piece was performed, as found in Concerts.ConcertSeason. The problem is that because each concert has more than one piece, the MusicI...

When message changes from text to HTML format, font is not the default
Hi, Environment: My outlook 2003 default format is HTML. The Default fond for new/reply messages is Arial. The Problem: I get a message in text format. When I manually change the format of this message to HTML, the font of the message is Times Roman. How can I make outlook automatically use the default font (Arial) as the font for messages changed from text to HTML ? Thanks, Ron. -- ronbarak ...

Can not get Excel macros to format/save charts--help??? :(((((
Help??:((( I've spent the last 5 days searching on this forum for problems similar to what I have but no luck! I am trying to use Excel macro to create a simple bar chart and to format the chart type/etc...but the macro keeps erroring when I try to run it. The debug points to " ' Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004. No matter what I name the chart, it errors. I'm advanced at Excel but not editing macros with VB. I'm at my wits end and hope that someone can help me :(( Hi, You do not set the Activechart ob...

How to not have formula change after inserting column from another sheet
One file - a few sheets. I run a macro weekly to copy column B of my CURRENT PORTFOLIO sheet and insert that data between Col I and J (Moving older data to the right - off the screen.) I then populate col B with this weeks data. That works fine, BUT another sheet of that file ( GRAPH) uses that data to track a few moving averages. To keep the GRAPH sheet accurate, after the macro I then have to modify the contents for the SOURCE field of the graph because NOW $I$1 becomes $J$1 and $I$28 becomes $J$28. I can't use an INDIRECT command - I get an error. Name = Weekly Moving Average, ...

Formatting when combining text & value in a cell
The value of my cell is ="Product Margin is "&Z5 Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I format the percent when combining text & value? Thank you for your time. One way: ="Product Margin is " & TEXT(Z5, "0.0%") In article <1157984365.490796.307300@i3g2000cwc.googlegroups.com>, "John13" <johnasmith13@gmail.com> wrote: > The value of my cell is > > ="Product Margin is "&Z5 > > Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I > format the...

Additional Table
Hi, Please advise me how can I add table to the Microsoft CRM and link it to the existing table in the CRM. Thanks. Inna. The current capability to link a table and reference an existing base Microsoft CRM table is via the SDK only, nothing out of the box. The SDK link has some example to linking with external databases/tables... Microsoft CRM SDK info: http://www.workopia.com/cgi-bin/ubb/ultimatebb.cgi? ubb=get_topic;f=11;t=000022 Frank Lee Workopia, Inc. http://www.workopia.com/Links.htm >> Other MSCRM Online Forum Resources >-----Original Message----- >Hi, >Plea...

conditional formating??
i would like the word "need" to appear in cells that are blank. i can do something similar with conditional formating where the blank cells turn red when empty... but i cant figure out how to have words inserted instead. Thanks You can't. Conditional Formatting can't insert text into a cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Daveed" <Daveed@discussions.microsoft.com> wrote in message news:34AE1C0D-0B46-4B4F-8AC1-5C9333A91D2D@microsoft.com... >i would like the word "need" to...

Conditional Number Formats
I would like to change the number of decimals shown for each number in a row of 50 columns based upon its value. For example, if the number is >100 then no decimals; if between 100 and 10 then 1 decimal place; and if <10 then 2 decimal places. I thought I could use conditional formatting, but it appears that technique only allows one to change fonts and backgrounds, not the formats of the numbers themselves. Is there any work-around or other tool I can try? Thanks in advance. You could try the conditional formatting addin at http://xldynamic.com/source/xld.CFPlus.Download.h...

Pivot Table conundrum
I am logging telephone calls per month and have been playing around with the pivot table function, I'm having a problem in that I want to specify the number of rows to the endth row, ie. 65536 to throw up the cost per call in the table so that in future when I add call data to the master sheet the pivot table will update autmatically, when I do this the result in the table records the number of events as opposed to the costs, I should point out that I am using the layout facility within the wizard correctly as instructed, it seems to work fine when the range is to the end of the las...

Changing Quote status from Active to Draft
After we re did our picklists for reps (were originally not working - not done right), it erased that data from all our past quotes. i need to run a work flow rule to chang the Quotes status from Active to Draft, but don't want to do that if it will affect the orders created. Can someone please help me with this. thank you It really didn't "erase" the data. The problem most likely is that you removed the entries for the previously saved values. You could just update the numeric value of the underlying records with SQL (not supported, but in this case safe). Othe...

how to turn off "smart" formatting
In A1:A10: -Type in some text. -Format as Bold and Underlined. In A11 (unformatted), type in a word and hit enter. On my machine, the formatting is automatically changed to Bold and Underlined. Is there a way to turn this "smart" feature off? XL2000 sr1 Tools / Options / Edit Tab / Uncheck 'Extend List formats and formulas' -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that mak...

How do I change chart cell from pixel to inch?
I am trying to modify a chart sent to me. Cell width is in pixels. How can I change it to inches. Brenda, Perhaps this site can help. It gives a pixels to inches conversion. http://209.196.177.41/01/01-09.htm ---- Regards, John Mansfield http://www.pdbook.com "Brenda" wrote: > I am trying to modify a chart sent to me. Cell width is in pixels. How can > I change it to inches. Brenda - You mean cell width or chart width is in pixels? Where are you reading this size? It's probably in points, by the way, not pixels. There are 72 points to the inch, and dependin...