I'm assisting with a workbook that has a LOT of conditional formats and they are being overwritten. Has anyone come up with a fool proof way to prevent...

I use Excel 2003 extensively with ODBC and MS Query to retrieve data from an external accounting program. Most of my worksheets have multiple external data...

I have a budget that when printed is one page wide and three tall. How can I add the column headings to the second and third pages?

Can I use a command Button to move cell valuse from one cell to another. I then want to reset a 3rd cell to 0. I have a spread sheet that I use to work out...

I have one spreadsheet which is linked to many. All of a sudden one spreadsheet will not link. when I try, it pops up with the place where all of my files...

We use ACCESS to export schedules in to Excel. When we try to run Excel to add up a column of numbers, the column will never add up. The only way that we...

Sorry for doing this here, but I have to see if I can post into this newsgroup... two of my posted answers in the thread with the subject "Need Help with...

I would like to be able to sort a pivot table by it's count values. I'm using Excel 2007. I'm looking to sort by Current & Expired Suppliers by count of...

I upgraded to Office 2007. Now when clicking on an Excel file in Windows Explorer, Excel opens without showing any workbook. I have to click on "open" in...

I have a shared workbook upgraded from Excel 2003 to Excel 2007 (saved as 2007 format). Both run in an ASP environment. The Excel 2003 OS was Windows 2003...

Hi everyone, I never imagined that the formula in the column would affect the sorting order in any way, but it does in my case. Below is the formula in...

I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This...

Does anybody know if I can create a Pivot Table using more than one sheet in a workbook? I've been using Pivot Tables for a while and have never been able...

I have a table of contents cover page (in excel) and 20 charts (each in it's own worksheet within the same document). I need to have the person be able to...

Hello, I am populating a pricing list. A combo box displays a product. I need the price to display in a separate cell. How do I get the individual prices to...

I am working with a spreadsheet created by someone else. I cannot view rows 1-6 on the sheet, but they appear when I do a print preview. How do I make these...

I'm trying to find a formula for inventory but the # of Cases & the # of Pieces are different for each product

Our accounting system exports to excel, problem is it sends numbers over as text. I can convert them easily to numbers, but then the next problem, it drops...

can you copy part of a cell, ie i want to take the first 8 characters of a cell and copy into another cell thanks David

I'm looking for recommendations on books to use to study for the MCAS test. I have passed the test for Excel 2003 and would like to do the same for 2007. I...