General

Insert Object Problem
Hi All, I inserted a PDF as an Object into Excel sheet . Now I see the PDF page in my Excel . But When I try insert a Text Box over the PDF image , the text box hides behind the image and do not come in front even when I try to send the object backward .. How do I make the text box appear on top of the o... 20 Apr 2010 12:24

Sorting PivotChart
Hi, In excel 2007 I want to sort data in the chart I made from pivot. I want them to be sort in descending order. The reason is, I need bar Pivotchart diagram to use as Pareto chart. I'm also using this new function in excel 2007 , "drill-down" or "drop-down" to multiple levels/layers in PivotChart. I want al... 20 Apr 2010 12:24

Row Height variations from computer to computer on same workbook
I've been sent a workbook by a colleague and on his workbook, a specific row has a height of 13.8 (23 pixels) and on my machine it is 16.5 (22 pixels). Has anyone seen this before and what do we need to do to ensure that it's consistent from machine to machine? Thanks in advance, Barb Reinhardt ... 20 Apr 2010 14:30

Pasting a value as an hyperlink
I have imported a list from a database of file paths to documents on our server, these data is currently formatted as 'General' Is there anyway of converting that value into a hyperlink to the said documents? ... 20 Apr 2010 16:32

Where can I find a Outside Sales Daily Call Report Template?
I could use some help, If any one knows where I could find a "daily Outside Sales Call Report" it would be a GREAT help. Thanks ... 20 Apr 2010 11:22

Need Help
Query: Say i have multiple sheets dated 04/01/10 to 04/30/10, each contain names, say A, B, C, D, etc... but these name does not appear in the same order in each sheet. Now data is in time format in front of A, B, C, D, etc. Eg. in sheet 04/01/10 A1 B1 A 1:00:00 D 1:53:00 C 2:45:00 ... 20 Apr 2010 11:22

RED before renewal date
A slight addition in the above formula =AND(F1<>"",OR(F1<=TODAY(),F1<TODAY())) Place the cursor in A1 cell and apply the conditional formatting formula, Active cell should be F1. (Active cell will have a white Background after selection also) -- Remember to Click Yes, if this post helps! ----------------... 20 Apr 2010 10:20

Sorting several columns
Hi, I'm trying to sort a sheet, sorting first by column A, then B, then C It works fine half of the sheet, but then column C isn't sorted correctly. Data format is the same, so that's not the problem. In column C sorting I've made my own list to sort by (st, 1, 2, 3, 4), and it works fine the first 20 rows. The... 20 Apr 2010 10:20

Conditional Formatting Help
I would like to apply conditional formatting for my spreadsheet with the following: Condition 1: If Column C Font is Bold then bold entire row and interior shade entire row gray. Condition 2: If Column B is Blank then shade entire row light yellow and format entire row font italic. Can't seem to figure... 20 Apr 2010 10:20

Date format
Text in Column E is a date mddyyyy I need to calculate the age but the text format of this date is throwing off the number. Any suggestions 8241938 4121939 8071965 2251950 2101940 12201964 1241980 5311961 3281982 3021967 9171961 10211977 -- Excel isnt just a program its a metaphor for life. ... 20 Apr 2010 20:48