Search results

sorry for the insistence dear excel gurus, but hopefully anyone can aid me on this doubt tomorrow? i apologize if it is a dumb question thanks!

hi every1 could somebody please advice whats the purpose of the replace existing category checkbox shown in the paste special dialog box displayed whenever the combo alt+ctrl+v is executed on top of a chart?? ive made several attempts to determine its usefulness but cant quite make it (???)...

thanks hui. know i see; and knowing is half the battle won!

hi all. this might be a very basic and easy issue to fix for all of you ninjas out there i have a problem using the convert function, how can i convert meters to square meters; or feet to square feet? or even so, converting meters to cubic meters and so on?! what should be the sintax of...

hello everyone i recently installed a language pack (spanish) to be able to switch back and forth between the primary language of the program (english, even though my windows is in spanish) and the secondary one: spanish i was expecting excel to show an additional tab in the ribbon area for...

hello all i read the following at microsoft's office site (refering to custom number formats); quoting: "Include an (@) character in the section where you want to display any text that you type in the cell" does this mean the @ character can be written in the positive or negative section...

sorry, this should be a new post. i apologize

hi peers, questions: can anyone share of any URLs where free downloads of raw data lists can be done in order to practice the many facets of excel 07? can anyone share of a URL that contains any free lists of the most commmonly useful Custom Formats (ctrl+1) for text and number, and list of...

thanks Dan_I; excuse me, i dont follow; you mention calculated field when the issue i had was with calculated items; well 2 issues specifically maybe you can take a look at the file one last time and see what i meant... i apologize if im a little bit lost here... sincerely grateful for...

thanks Dan_I; excuse me, i dont follow; you mention calculated field when the issue i had was with calculated items; well 2 issues specifically maybe you can take a look at the file one last time and see what i meant... i apologize if im a little bit lost here... sincerely grateful for...

were able to find something out on this matter?

hi dan_l yes! not only did the calculated item disregarded the report filter in place that pointed out to specific items (Portatiles items of the Category field) to show in the pivot table; also the formula added "new items" (not existent in the source data) to all of the original products...

dan_I, here is the link to the file http://rapidshare.com/files/442004504/bizarre_result_on_calculated_items.xlsx here are my concerns/doubts: 1) In the proyeccion 2011 1 tab, for a pivot table with a report filter item called Portatiles, i added a calculated item. The calculation was to...

hi boernecheryl. im a novice user but i think i can help in clearing out any misunderstandings on your Q. did you try to access the value filters by right clicking the Values area? cause it wont work unless you do the right click either on any item of the column label or the row label...

dan_I, thanks a lot. i will upload the file today. i'll confimr today with a post inlcuding the questions on the matter.

could anyone provide some help on pivot tables' calculated items? the formula is giving me some really bizarre results i can upload the file in question to rapidshare so that it is easier to understand what im talking about any good samaritan, please let me know thanks so much to all of ya

hi everyone. 2 Qs to anyone outthere willingly to help! 1st.-is it possible to create a calculated field formula using a conditional function such as IF and referencing to other Field Names and/or Item Names BESIDES the Field in which the formula or calculated item is being inserted on...

hi everyone; how can the additional fields created by the Group Command Option on a Pivot Table be Deleted from the PT? Im not talking about removing them from the PT (but still show on the Field List Window) but actually to erase them off the Pivot thanks in advanced 4 your shared knowledge

is it possible to create a calculated field formula using a conditional function such as IF and referencing to other Field Names and/or Item Names BESIDES the Field in which the formula or calculated item is being inserted on? thanks

john! nice to meet you. thanks for sharing that info. have a nice year

thanks hui just to double check and close this issue, please let me know if i was right when i said the follwoing last night: does the filter work only by looking out for the grand totals? either by row or column label (depending on the field thats being filtered)? let me know if i am...

thanks hui. i think i just got an understanding of how the value filters work. tell me if i am right: if i used the sum summarization subtotal for my data, does the filter work only by looking out for the grand totals? either by row or column label (depending on the field thats being...

hi all. i am new to chandoo's. i am starting to learn as much as possible all the intricacies of excel 2007. especially the advanced features such as filter, tables, pivot tables, macros, and so on. while studying the pivot table features i came up with a small table of data. i have by far...