General
in [Excel]
|
Date and Time Picker issue I am currently using Excel 2007 on a windows XP pro OS. I am inserting a DTP control into workbook, the control works until I close the workbook and open it again and the control is replaced by a red X and the control no longer works. My system originally did not have this control, I downloaded the mscomct2.ocx... 27 May 2010 18:11
saveing a spreadsheet as html want to keep the outline useable Using Excel 2003 I have a spreadsheet that contains Daily infomation I group this into 4 teams and set it up to display the montly totals as an HTML file. Is there a way to keep the + and - of the outline on the right side interactive? this would allow each person in the team to drill down and see the daily. ... 27 May 2010 18:11
Getting a Sheet to Choose to Display Other Sheets Hello, I have a payback workbook with about 6 different payback sheets, for the six different years in our payback range. I would like to create a master sheet and link the 6 different payback sheets to it, so whenever I change some numbers on my formulas sheet, the master sheet selects the correct payback... 27 May 2010 18:11
Pivot Chart Trendline? Excel2003 ... when my Pivot Chart is Type "Column" ... I have ability to add a "Trendline" ... However, when I change my Chart Type to a "Stacked Column" .... "Trendline" is now grayed out??? So ... is there a way to add a "Trend Line" to a Pivot Table "Stacked Column" Chart? Thanks ... Kha -- Kha... 27 May 2010 18:11
Format Pivot Table Is there a way to format a pivot table and when the data is refreshed the formatting stays. Currently I change the formatting and then the next time I refresh it reverts back to the original format ... 27 May 2010 18:11
Return date of an action Hi, I have a gantt chart which has columns headed by dates A B C D E F 1 10/12 17/24 24/12 31/12 1/7 2 Do A 3 Finish B 4 Start C 5 6 7 I would like to put a formula in colum F to show the date that the acti... 27 May 2010 18:11
Formatting Text to Numbers for Dates I'm currently working with a column of dates. Some of the dates are text and some are numbers. The dates are in the following format 21/6/210 or 4/12/2013 (date/month/year). I used =isnumber() to verify cells. Half of the coulmn resulted in false values. I'm unable to format the dates to other formats, si... 27 May 2010 20:23 |