I recently upgraded from Excel 2000 to Excel 2003. One of the spreadsheets I've worked with using Excel 2000 has many links to other spreadsheets, all of...

Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the...

Sorry, not very efficient in Excel, but have the following problem : When clicking on a function button on an existing excel sheet, it tells me "file could...

I am trying to find how do I make a cell so as to when I click on it, It automatically launches a stored PDF file that I have in another directory. Hyperlink...

I see questions about this all over this group, but no answers. When I goto Edit Links, the Change Source button is greyed out. It was working just...

Hello Everyone, I have a user who is running Excel 2003. He has a sheet that is nothing but hyper links and notes about what those links are. When a doc is...

All, I am having a problem with Mathematica Link for Excel. When I try to generate some graphics I get -Graphics- back but no graphics is shown. Example...

All, I am having a problem with Mathematica Link for Excel. When I try to generate some graphics I get -Graphics- back but no graphics is shown. Example...

I thought this would be easy to do, but so far... no luck. I have created a simple spreadsheet in Excel 2002 that lists the DVD's I have in my collection. I...

Ho aperto il mio nuovo sito è in fase di costruzione ditemi se vi piace.... www.royaldj.tk Tanti Saluti Dj Royal

When the user uses an autofilter, the hyperlinks (in a separate column) do not sort with the rest of the data. The hyperlinks move, but don't hold with data...

I have a worksheet with cells linked to files contained in the same folder as the spreadsheet file. When I created the hyperlinks, the full path was included....

Hello How to make "Microsoft Excel This workbook contains links to other data sources To update all linked information, click Yes. To keep the existing...

How to do a web query on an internet explorer object using macros how to do a web query on an web browser on an user form using macros. Please respond to...

I am trying to create a link between 2 worksheets - i have copied the source data and pasted it to the destination sheet, the data appears but there is not a...

Hello, i have to update all cells with zero if it is blank according to a particlular date. In other words, if the date is todays date and the cells are...

Yes it's definitely possible if you handle your queries with VBA. Don't know if Excel's Data menu option to query an external database can. Actually, I think...

Well, Ardus That's something I hadn't stumbled on before and find it very helpful Thanks "Ardus Petus" wrote: Use : SELECT * FROM TABLE WHERE YEAR = ?

I have a scenerio where we want to make 6 regional workbooks that contain customer contact info and other key data. We want to have a "master" book that...

Hi, I am using Excel 97 and every now and then when I copy a worksheet in the same workbook to reuse as a new worksheet base, I get an error message: "A...