General

Pie Chart Question
Hi, I am tring to make a pie chart that needs to include 2 pieces of information for one series. I have two columns of information (number and value) that relate to one person. There are 5 people all together. How do I do this? ... 20 Nov 2009 10:05

Using a cell's value in a macro command
Hi, I need to use a value of a cell in a spreadsheet in a macro command to copy data. For Example. cell A1 = 28/09/2009 Sub Workbooks.Open Filename:= _ "C:\(Value from A1)" End Sub Thanks, Tom ... 20 Nov 2009 03:29

How do extract cells from hundreds of excel files and put in one n
I need to extract expense totals from employee expense reports and put in to one file for import then in to the payroll system fo reimbursement. ... 19 Nov 2009 17:30

excel 2007 query question
ok, ed. i finally have an update. if this goes unseen since it's so old, i'll repost. pertinent code: in 2003: a query refresh dialog appears when the workbook is opened, enable or disable automatic refresh. If Application.Version <= 11 Then ws.Range("A6").QueryTable.Refres... 20 Nov 2009 15:44

Formating cells - "Too Many Different Cell Formats" Error
Krisml: I have been fighting this same "error" for two weeks, and it is impacting a huge Budget workbook with about 10 worksheets that are interlinked. The most bothersome were cells that have date formates, becasue they all change to numbers. But all of the simple formats, like numbers as currency keep chan... 18 Nov 2009 16:53

text is getting cut off when printed due to row ht.
In my spreadsheet the row heights are varied and look the right way, when I print my spreadsheet the rows are smooshed and text is cut off across the top. (Excel 2007) ... 18 Nov 2009 15:45

Stop Scrolling When I double-click cell wall
For Excel, how can I disable auto-scrolling when I click the bottom of a cell? It is an extremely annoying function when trying to work fast in a spreadsheet and it happens. Thanks you ... 17 Nov 2009 14:04

vlookup with 2 criteria or more
Dear Masters please help me function of vlookup using 2 criteria A B C 1 X a AB 2 Y b AD result : input input result X a AB Thanks in advance ... 17 Nov 2009 02:52

csv, how to set excel to auto load
I want to double click on a .csv file and have it automatically load in to excel 2007. Currently it opens it and puts all the data in column A. If I close it and use data import all is fine. Ridiculous for people to send me .csv files. I have to save first them data import. Another way? Add-in? ~Gina_M~ ... 17 Nov 2009 10:37

How to XML Map Repeating Rows?
I'm trying to map XML to a range of rows but, for some reason, Excel (2007) is only mapping it to the first row of the range. I've created an XML file and imported it. Then, I right-click on the root element and choose Map Element. Excel asks "Where do you want to map the XML elements?" I click and drag a range... 12 Nov 2009 17:24