General

Linking Workbooks
I have a new problem that's come up after upgrading to Office 2007. I am linking my reporting workbook to the daily workbook that is updated by someone else. The cells I am linking to are merged cells. When I insert the link I get... ='[0203 Company 2.xls]Day'!$J$5:$J$6 which results in a #VALUE error unle... 11 Feb 2010 15:05

Linking graphs to other spreadsheets
Hello All, I have two seperate workbooks, one of the two has graphs that pull data from the other file. If I only open the file with graphs, the data in the graph is accurate, but the axis on the bottom is not accurate (The bottom is a date format) If I open both files and then look at the graphs, the axis loo... 11 Feb 2010 11:41

Auto Populate & Name Recognition
Can Excel 2003 recognize a name in a call in one workbook and then auto populate the cells from the original worksheet by name recognition? -- Leigh Anne ... 11 Feb 2010 12:49

Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
Hello, How can I format the number 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds? Thank you! ... 11 Feb 2010 11:41

compare two columns and pull out differences
I have two columns of numbers. I want to know the numbers that do not have a match or are not in both columns. But I need all of each column to be compared to all of the other column...not cell by cell. It would be great if I could pull out the differences and put them in a different column. Looking at two long... 11 Feb 2010 11:41

cell data management
is it possible to take a cell with a full name, john bob jones for example and split into 3 cells easily without having to retype the information manually? ... 11 Feb 2010 12:49

Autofilter Problem
Autofilter Arrows disappeared from Excel Spreadsheet. If I go to Data / Filter AutoFilter is checked but grayed (can not check / ucheck). Can anybody help? Thanks, Oscar. ... 11 Feb 2010 11:41

Creating a list from a different worksheet
I would like to create a list in sheet 2 from data in sheet 1 but when I click create list and go to select the range it will not let me click on the tab for sheet 1 to select the required data. Could somebody point me in the right direction please? ... 11 Feb 2010 08:19

How to translate a getpivotdata formula into a cell reference
Hi all, I want to be able to get the cell reference (in the format A1) of a GETPIVOTDATA reference. For example: =(GETPIVOTDATA("Sum of Qty",'$A$5,"Customer Name","ABC Company")) pulls data from a corresponding cell in the table. That reference is A10 but I want to get this from the actual GETPIVOTDATA ref... 11 Feb 2010 06:07

when i save a file that i have worked on, excel7 closes down work.
i have recently purchased office pro 2007. Excel 2007, when i save a filethat i have worked on, excel closes down and work is lost, done all updates, re installed from disc, please help i have lost 2 hours of work this moring that i need for a report ... 11 Feb 2010 02:51