General

MS Excel 2003 - Advanced Features Add-In
The Advanced Features Team is pleased to announce the release of the first version of their Add-In for MS Excel 2003. Part of this realease are the following functionalities: * Easy and powerful connection between MS Excel and MS Access * K-Means clustering algorithm * Additional User Defined Formula... 4 Mar 2010 11:13

Scroll Bar question
This is kind of hard to explain, but here it goes. Let's say I start with a spreadsheet that has 10,000 rows of data. Then I decide to delete 3,000 of these rows. When I use the scroll bar to go to the bottom of the spreadsheet, it takes me to row 10,000. Or, if I use control + end, it goes to row 10,000 as... 4 Mar 2010 11:13

Calculating total amount in a Pivot Table
Anyone got an idea how to solve the problem ? ... 4 Mar 2010 11:13

weird characters are displayed
Hi, I am importing a TXT file into excel, by right clicking on the file in Explorer and then using the option 'Open with'. The file displays correctly, that is the columns etc are all aligned. In my Data I have some special characters like German and French for names, Like for eg ( Väpp ) the Umlaut (..) on t... 4 Mar 2010 10:05

gridlines in pivot table
for easier reading i want to show the gridlines inside the pivot table. when i insert a pivot table now and specify the gridlines options in the printer set up, the grdlines print only outside the table. thanks for your help -- aprilshowers ... 4 Mar 2010 14:41

Replace Number
I have over 400 entries in a colomn which start with 0015...and then more numbers. how can easily edit on mass so that they now begin with only 015 ??? cheers ... 4 Mar 2010 10:05

How to reference a spacific cell in multiple saved excel files.
I have an excel file for each day of the week with certain different values. I need to pull a value from cell "C36" from each of the saved files. I need to put these values in a separate excel file containing only the date and the value of cell C36 for each date. ... 4 Mar 2010 06:43

anyone experiencing graphics instability in Excel 2007
have written,(am writing) an Excel Spreadsheet Excel 2007 PC ver to track AFL (Australian) results and maintain a tipping comp. No probs with the database aspect but sometimes I get graphics, particularly activeX controls superimposed on not the sheet they reside. This will usually disappear by scroling the gar... 4 Mar 2010 06:43

Excel 2003 + script to open and automatically close an excel workb
Hi, i have a scheldule to run at a certain time, the excel sheet will open, run a macro and automatically close. The trouble i'm having is the workbook keeps staying open and not fully closing. Is they a better way to do this? Help would be greatly appreciated. Neil. ... 4 Mar 2010 12:22

Excel 2003 - emailing
I have set up a button and when pressed it will send to specific people, below is the code I have, what i need it to do now is whoever sends the email i want that user automatically CC into the email? Is this possible? Thanks. On Error Resume Next With OutMail .To = "neil.holden(a)test.com; dav... 4 Mar 2010 06:43