General

Can I specify what order to refresh tabs?
I am using Excel 2003, and I have a report on Sheet1 tha is using vlookup formulas to Several other sheets in my workbook. I have some sheets that are pulling in Queries from a database and i have some sheets that are pivot tables. I have all sheets set up to refresh on file open, but i want to make sure that the sh... 15 Jan 2010 14:58

Label ?
Hello, In Excel 2003 I created Data Labels in my worksheet and can't remember how to bring up the properties window so I can make changes to the text. Also, I would like to delete a few of them but when I click on the label a square white box appears in place of the label and nothing else happens. Can anyone ... 17 Jan 2010 08:21

Determining elements that make up sum from a list
I have a list of data. This is a clearing account that does not clear. Total of this account is +90K and change. I need to know what numbers make up that total from the list of all transactons that have come through this month. Reverse engineering for sums. ... 15 Jan 2010 12:44

how do i copy data from online so it goes into separate cells
In earlier excel products I could copy data (ezpass info) from online and have it go into separate cells. With office 2007 - It only takes one line of the selected data and puts it into the first cell ... 15 Jan 2010 12:44

Can't open Excel 2007
I've just got the Microsoft Office Suite as a download from Microsoft and Word and Powerpoint are working but I just get an error message: "This update paskage could not be opened. Verify that the update package exists and that you can access it, or contact the application vendor to verify that this is a valid ... 16 Jan 2010 13:56

IS there a way to invert rows?
I need to completely flip an address data record. Sorting does not work because it only works by ascending or descending by fields. Is there some way of flipping rows? ... 15 Jan 2010 14:58

Combo Bar-Line Graph with single list of data
Hi, I'm trying to create a combination graph where my data for 2008 and 2009 shows as the year total represented by a bar. I want the 2010 data to show by month. My data is listed by Month in Column A and the total by Month is in Column B. Date Total Sep-08 7 Oct-08 9 Jan-09 ... 15 Jan 2010 11:37

Creating a customer statement of account
Hi All I was wondering if one of you kind people would be able to help me with the following: I have started to use the Invoice Tracker template to track my customer sales invoices which is fab, however, my problem now comes as somehow, i need to create a statement of account for each customer who has outst... 15 Jan 2010 10:29

Can I refresh worksheets in a specific order when I open a file?
I have multiple worksheets that contain data from MS query that I want to refresh on open. I also have several worksheets that contain Pivot Tables that I want to refresh on open. I want to be sure that the query worksheets update first, then the pivot tables. Is there a way to specify what order the sheets ... 15 Jan 2010 10:29

Excel 2007 with two windows in Windows 7
Hi, I'd like to be able to have two separate Excel windows every time I open an xlsx file, whether by double clicking it or by going to the MRU file list in Excel 2007 or through the open dialog. I had this in Excel 2007 in Vista, using the reg patches that are out there and changing the dde settings in E... 15 Jan 2010 09:22