automatically update the pivot table
I am using excel 2003 How can I update the pivot table automatically when I open the workboolk ? Thanks -- eva cheng ... 25 May 2010 06:57
i deleted info in excel then saved. can i recover deleted info?
I have microsoft office 2003, and was using excel. i deleted some columns to copy on to another worksheet. i then closed all the worksheets and agreed to save changes....by mistake. is there any way of recovering that data that i deleted? heres hoping! ... 25 May 2010 04:48
How to remove the cell reference in a sheet at once
Hi, I have a sheet where there are many cells are fix (reference cells) using the F4 key. Is there any way i can remove the effect of the F4 without going to each formula and them keep pressing F4 to remove the reference??? ... 25 May 2010 10:13
Count number of days from the last entry?
I need a formula to count the number of days from TODAY() to the last entry in column "J". Column "A" is date column. ... 24 May 2010 22:22
in column A 1-16 will put a name Column B list A-P Column C P,A,B,C,D so on Column D,O,P,A,B,C. so on down to 16. I want to be able to use a formula so when I enter A-P it fills in moving 1 column and 1 row each time. Thanks Karl ... 24 May 2010 20:11
Working With Dates in Excel
Hello: I use Excel to keep up with information like the number of days I was employed by a given employer. I included the first day of work on my worksheet for example as 1/1/2010 then I type the last day I worked there for example 12/31/2010. Now then with the first and last date displayed on my sheet for c... 24 May 2010 20:11
Need help looking up data-vlookup isn't working
I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! ... 25 May 2010 17:59
Zero's plotted in chart?
Why would I show zero's for a column of data in my chart that are actually very large(56869685). Some of my charts have date segments that are missing when the data is there in the table? I checked the formatting for the data in the table and it is all set to a number, no decimal format. I don't understand? -... 24 May 2010 17:57
Delete an Add-In?
Excel2003 ... Tools ... Add-Ins ... Automation ... I inadvertently selected one of these that I did not want ... Now how do I remove it from my List of Available Add-Ins ... Thanks ... Kha -- Kha ... 27 May 2010 20:23
Making a comment using a cell?
Gord, Is there a way to do this referencing a cell on another tab? For example Sheet2!B1 ? Thanks. "Gord Dibben" wrote: Sub Comment_Add_Cell() Dim cmt As Comment Dim r As Range Set r = Range("A1") On Error Resume Next r.Comment.Delete Set cmt = r.Co... 24 May 2010 20:11