I created an excel spreadsheet and did a mail merge to word. The problem is that I have apparently lost the excel data. Is there a way to convert the mail...

Hello all, I have a Win 2000 Pro computer with Office 2000 and Norton Antivirus 2004 installed on it. When I have tried to open any of the Words (.DOC) or...

I have some xl files that have many macros in them. For example 20 xl files with 10 macros in each file. I have the following macro in it's own xl file that...

This might work for you if all your workbooks are in the same folder. It looks at each sheet in each workbook. But I'm not sure what to do with it after I...

I have a password secured Access 97/2000 database that I'm trying to attach to via Excel 97/2000 to make pivot tables, but I can't use any of the database's...

Hi I have an excel sheet with dialog box having default values.I want particular records from the sheet when I click any value in the dialob box.Like when I...

I have set up a spreadsheet in Excel on my desktop to be able to enter in lab data and it works great. I have recently purchased a Compaq I Piq h3650 with...

I would like to: test the code or button that I inserted with code on spreadsheet. allow the user to launch the spreadsheet in run mode. (newbie) how to do?

Dropping the security level on my workbook will do this right? excel says it's not reccomended because of viruses, is there another way? I have macros in my...

Dear readers out there, A colleage of me made some excel sheets. They are very slow with scrolling. Even when i clear all the info and tekst in the sheet; so...

I am working on huge spreadsheet. From time to time when I open the file it tries to recalculate. This file takes about 2 hours to recalc. I know I have...

Two questions, 1st: Is there a way to auto refresh a pivot table other than "on open" when opening the worksheet? 2nd: Is there a way to change the layout such...

Hi All, I have a pivot table which has a "Sum of Amount Authorised" in the data area which is formatted as a number with 2 decimal places. When I double...

I have an application that requores that I use COUNTA over a column range that varies from spreadsheet to spreadsheet. Is there any way that I can incorporate...

Hello -- A workbook I was given shows 2 worksheet tabs. Cells in each of these worksheets reference 2 other worksheets, as in (H33) ='cannot see...

Hi! I have been given a database of names, addresses and website addresses in an Excel spreadsheet. The website addresses do not appear as a hyperlink. Is...

I have a single column of values, invoice numbers. I would like to sort the column by the last digit of the invoice number. Is this possible, and if so,...

Good day; I am creating a template that requests the user to assign a text value (L,M,H). I need to convert this text value in multiple cells to a numeric...

I find the single worst thing about the VBA editor in Excel (I use Excel 2000) is that my mouse scroll wheel doesn't work on the source window. Is this normal...

when i send an excel spreadsheet to myself i can open it but if i send it to someone else by email when they go to open it says more than 64 unable to open. i...