I am using Microsoft Office 2000 on my computer, but I have a spread sheet which was designed in Office 97. This spreadsheet works fine without any errors in...

I'm prototyping some basic functions before building a large workbook and populating it with hard data. I have 2002 on this machine which is ok because my...

Hello, Is there a certain palate or a way to select the 2003 Excel color palate in 2007 Excel? We have users whithin our company that use 2003 and others...

HELP! I have a ton of spreadsheets that were created with excel xp, or 2000, or 2002. If I bring up a spreadsheet created in excel xp or 2000,...

This is my data: CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on??

Hi there, I am wondering if the basic edition does not carry all of the functions available for use. I had designed an excel sheet for a friend and it...

Is there a way to populate text into a cell from a list dependant to the contents of another cell?

I am in need of assistance to create a find and go to FORMULA with bells and whistles. When partial or full info is entered into sheet/cell "Calc.!A7", it...

Hi, I have this function =SUM(IF($D$25:$D$993="x",IF($B$25:$B$976=""&A3,1),0)) from excel 2003 and now have converted the spreadsheet to 2007. I have...

Where can I obtain a list of 2003 functions that are no longer functional in 2003? Also, we have a number of templates built in 2003. How do we know if a...

The following macro works fine in Excel 2003 but generates a compiler error on 2007. Any ideas or direction? Sub WhoRang() Dim ButtonLabel As String Dim...

I created a protected worksheet in Excel 2003 for which I utilized the Allow Users to Edit Ranges feature. Works fine for those working with XP or 2003, but my...

Hello group. I have a VBA/Macro that I put together in version 2003 that works just fine and works fast. In 2007 it works but very slowly and makes the...

In a column, when I enter whole numbers with no decimal points, the auto sum works correctly (such as three rows of numbers like 4567, 33425, 88483). But when...

I am running Excel 2000 in Windows XP. I received an email with an .xls attachment which, when I opened gave me the macro warning. I didn't need the macros...

First posted a week ago to excel.programming. Thought I'd try again, adding excel and excel.worksheet.functions hoping for a reply this time. Office 2003...

How do you calculate the percentage of Improvement when the start value and the new value are both negative? For example if in 2003 we had -$15,000 and in 2004...

Dear all, I want to find a 2004 calender in Excel format, who can help? Thanks

Just a reminder about the 2005 Excel User Conference. Details can be found at: http://www.exceluserconference.com/ The conference will take place on Friday,...

Just a reminder about the 2005 Excel User Conference. Details can be found at: http://www.exceluserconference.com/ The conference will take place on Friday,...