2003

Hello all, First time poster and I appreciate your patience. I have done some extensive Googling and can not find a solution to my issue (could just be my lack of searching skills). I have created a fairly simple list in Excel 2003 with about 10 columns that will be updated daily. It will be...

Hi can anyone please help me with a macro code please I want to hide auto filter on the following columns A,B,C,F,G,N,M,AB,AD But want to show in all other columns How can i do this? been trying all day and i bet it is simple lol i am using excel 2003 :confused:

This has been sending me crazy all day. Essentially I have two columns - one named category and one named time. There are three categories. These are certain words however for this purpose I'll call these A, B, C (although this final category is always expressed as "C:[sub category]" which...

I have a Word 2003 document that is an annual report that has about 20 Excel Objects copied into it (copy from Excel, Paste-Special-Excel Worksheet Object in Word)... the problem I find is that everytime I have to copy another table into the word document, the document size increases quite a...

I have frozen panes and hidden rows using Excel 2003. When I open the .xls file in Excel 2007, the freezing of pane and hiding of rows is ignored. Is there an incompatiblity in the way these states are saved in the two versions?

Morning, I've been trying to figure this out for days now and I'm getting nowhere fast and no matter how much googling I do I just can't find something that does what I need. I have a very basic worksheet, albeit with 200 rows, that includes names and the dates that their contracts are due to...

Hi there, I use excel 2003, and have a 15MB s/s. A colleague of mine pasted in a pivot table from a previous version of the same s/s bloating it to 21MB (the "save data with table layout" option was ticked by mistake). Removing the pivot table has reduced the s/s to 18MB - but not to 15MB. So...

I would like to create a Pivot Table in excel 2010, and then send to users who are on excel 2003, and for those users to at least have the 2003 pivot functionality I have tried saving as "excel 97 to 2003", but this does not help as the compatibility check says the pivot won't be useable. I...

Hello, I'm having some trouble making a dynamically updating chart in excel 2003. I'm fairly new to excel, but my boss wants me to make a graph that will update every week as we recieve more info into a certain file. Basically it's the alcohol drinking habits of the southern states, broken...

I recently migrated from Excel 2003 to 2007... what a difference! I felt that I was a power user in 2003, and like a newbie in 2007 -- it will definitely take some getting used to. In 2003 I used the Customize option to create menu buttons to run macros. The macros are called by pressing the...

Hi all, First of all, I apologise if this question has been answered before; if it has I haven't been able to find it. My query is this - I have a group of deadlines for courses done by employees and I need to highlight a) when they are overdue, b) when they have 2 months to go before the...

I got this VB script last time here. And it works great in 2003. But now we have 2007 and it does not work can you help me. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$3" And Target.Value = "HideDues" Then ActiveSheet.Unprotect ("cover")...

Hi, I run a macro everyday and have been using 2003 until just recently. Our office has switched over to 2007 and now the macro is erroring out. I have tried a few things but nothing seems to work. I'm receiving a "Run-time-error' -2147417848 (80010108)' Method 'Sort' of object 'Range'...

I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in Windows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problem is...

I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in WIndows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problems...

I am needing to format a spreadsheet using 2003 which only allows 3 conditional formats, but I have 4 conditions. I need to highlight the row if column W has a G - green (colorindex = 35) R - red (colorindex = 3) Y - yellow (colorindex = 36) O - orange (colorindex = 44) Any ideas on how I...

Hi all, i can´t get this code to work correctly in Excel 2010. It is used to make simple organization charts, by pasting a Autoshape circle and connecting it with a line to another circle, this works fine. The macro can also be used to remove the circle and line again by using the same...

I have a master table of values that I am using to compare experimental data against. The experimental data has some blank values which must stay in the data set but must not be compared against the master table. There are 286 rows of 13 cells (which only contain 10 cells and 3 blank cells as...

I am using Excel 2003 (xls file). My problem is similar to many permutation/combination problems but I looked at the other threads and could not find a way to apply the solution to my problem (I am not very Excel-competant, sadly). I have 13 objects that I am using labels (A,B,C, etc) for. I...

Buenas, Tengo excel 2003 y necesito realizar una suma Tengo una columna con montos y a la lado una con la cantidad de días que pasaron a la fecha actual. Yo necesito sumar solo los montos entre 0 y 30 días, de manera de que a medida que pasa el tiempo, no considere los montos cuyo plazo es...