2003

I'm having a few issues calculating an average that includes a changing dataset. Column A: Date data in entered Column H: The data i want to find the average of Cell L1 - Where I need the result. The number of data rows changes every day but the dates the data relate to aren't always entered...

Hi everyone I'm using Excel 2003. I have a spreadsheet which contains an =today() function. When I view the spreadsheet it correctly displays today's date and updates each day as you'd expect. When my colleague opens the same spreadsheet on her machine, the today's date function is not...

I have a very unique situation here... I have a utility at work that generates a spreadsheet. It is an excel 2003 spreadsheet, which is "Book1" and unsaved. The user needs to run my code to grab some data from this spreadsheet and not have to save the excel 2003 workbook to their machine...

Hello I will be emailing excel docs to different people who may or may not have the same color palettes as I do. I want them to see the doc in the same colors as I do but I don't want them to have to do any work to make that happen. Is there a way to email the color palette with the doc and the...

Hi all, Need some help with this code, few problems i did have are that it use to get to the point where it asked for permission to send, you would click yes and it would look like it had sent but then wouldnt have sent (nothing in sent items) new problem is that it does not seem to work in...

Some users still have 2003 loaded and don't want to upgrade. I tried having them open the .xlsx file, it converts fine, but opens as read only to "protect the original document". They can't save anything. Is there any fix short of giving them only .xls files ? Mike

Hello, I've been recently converted from 2003 to 2010. In 2003, I used to have 3 Open icons that were hyperlinked to 3 docs I used daily. To do this, I had to... 1) Right click on toolbar, choose Customize 2) Drag the Open icon to toolbar 3) While Customize window was still open, I would right...

I need to keep a running tab of times that fall according to certain time parameters. There are 3 columns that have <=60, 61-120, and >120. I have formulas successfully plugged into column A and column C. The significant hitch is that I am forced to use Office 2003 at work. I know countifs...

Heya Everyone, The VBA code I am using for creating a pie chart works in 2007 but fails in 2003. Essentially it looks for all sheets with Test in A1 and then when located, selects G2:J2, then the last row of G:J to make the pie chart. It fails in the bolded section section. (Thanks to Mike for...

Hey guys, this is my first time posting on the forum but I have always gotten a lot of help from reading other posts. Here is my question: I have a workbook in which I have created a tracking program with a user interface, the information posted to the interface gets stored into hidden...

Helping a friend w/ 2003. Using the following website info I'm trying to set up a recurring task as directed to automatically send out an email that needs to contain an Excel attachment. http://support.microsoft.com/kb/239087 This may not even be possible to accomplish. The object is to...

Hi all, I have tried to search around for this so please forgive me if this is an issue previously covered. At work we use Excel 2003, wheras at home I have Excel 2010. I'm having some problem using work spreadsheets at home, specifically running macros with Edate and Yearfrac in. I think...

I have recently had 3 instances where my error handling is not working the way I had intended. I am not sure whether these instances are related or three different problems. I have used error handling many times before and it has worked the way I intended it, so I am hoping this is not just my...

Hi, I am trying to re-format a sheet. I know how to delete empty rows by VBA, so I can clean this up after. I'd really appreciate some help...I think it involves xlup and fill, but can't for the life of me work the sub routine out. Note: The number of rows in the sheet can vary, so the last...

I first want to say "HI!" to all of you members. I usually sneak a peak at this site for some quick help, but this time I am really stuck. I am trying to create a complex timeline of audit controls for a company. This excel workbook includes three worksheets -- Summary, Status, and Details. Of...

Hello there! I haven't posted here in a long time but have certainly searched through here over the months to get help on any number of things. Thanks to the community for that. I love this place! My current dilemma is as follows: I'm in a corporate environment where Excel 2003 is the...

I have a customer that uses Excel2003. I use 2010. To save time, I utilize conditional formatting on the report. When I send the report to the customer, obviously, that formatting is not visible. How can I copy/paste/save that "highlighting" in 2003, while continuing to use the conditional...

How do I write a macro that will save a 2003 version of a file (.xls) as a 2007 version (.xlsx)?

Hi all, I am actually looking for a way to invoke a few file operations when working in Excel (Using VBA or so). Yet, i want the criteria for the files to be user customisable (the filename differs). (1) In detail, i have a folder with report files from a WMS/PWS server. This folder contains...

Hi All- I was looking for a link where there is a list of all the 2007 functions which are also available in 2003 but with different formulas. For instance; 2003 had SUMPRODUCT while 2007 has SUMIFS. Both of them are the same functions but different formulaes. Where can I find the list of...