2003

Hello all! (Newbie here) I'm currently doing a multi data graph on Excel 2003 (Strain gauge experiment), the problem I'm trying to get my head around is how to set the data to pass through or start at the origin? If the data doesn't then I'm presuming it will display it over or under (0,0)...

I just ran into this issue now using excel 2007 and don't recall it being an issue with 2003. I have a protected worksheet and when I tab over a few cells and hit enter it takes me down one cell rather than to one cell down but in the same column as before. i.e. Before in 2003 if I started in A1...

I am looking at customizing the chart templates for excel 2003. I have few questions. 1) In excel if I add an chart, it comes up with some default settings like borders, grey background etc. How do I modify the template of each chart for multiple things like border, color etc, so that for the...

I am trying to build a macro to be placed in a blank spreadsheet for use as a template. My development platform is Excel 2003 on Windows XP SP2. The script was initially recorded as a macro against a single data file with absolute range references and worked both on my develpment platform and on...

Guys I have a company sheet that is being developed for use by others. I need to lock the sheet in terms of formula editing etc but need to allow users to add data into the list and for the list to automatically expand when the user reaches the end of the defined list. The list function does...

Hello, I've created a file in XL 2003 and then did most of the editing in 2007, now when I open it again in 2003 it takes ages recalculating the cells on one particular sheet, but it is fine if opened in 2007. I'm trying to work out which element of the file could be causing the problem so...

Please help, I am trying to send a excel file on a monthly basis to a set email address(s). I use excel 2003 and have very little to NO experience with VB.. Your patience and guidence <link rel="File-List"...

In Excel you can make multiple selections in a spreadsheet by holding down "ctrl" while making selections, however normally Excel does not allow you to then copy these selections all at once and paste them elsewhere. I found a tip that suggests that this may in fact be possible using VBA...

Hello, I created an Add-In for Excel 2003. Lets call it MyAddIn.xla In this Add-In a have a function myfunction(). On computer1, the Add-In is in this folder: C:\Program Files\AddIns\ On computer2, the Add-In is in this folder: C:\test\ On both computers, the Add-In is installed and selected...

Hi We are having a rather bad experience with our Excel 2007 spreadsheets. It seems that when saved out as 2003, all the formatting is removed from the document. No more borders, background colors, text colors, nothing but text. I've been trying to figure out why and can't come to any...

I successfully used the following functions to create a unique list of "units" (store numbers in a multi-store list) thanks to help from this site. However the list that is created is not in alphanumeric sort and I need the units to be sorted alphanumerically - hopefully without having to click...