I have a spreadsheet with hyperlinks to a folder containing different types of docs. - .xls .doc .ppt .pdf. The hyperlink goes to the folder but does not...

I seem to know just enough about Excel to be dangerous, and therein lies my question. I have a spreadsheet (1 sheet) that has some 600 (and climbing)...

Hello, I have a summary sheet which links to many (20ish) password protected files. Every time I open it or update the links, I have to enter many (20ish)...

Hi, I often need to copy some data from internet home page for further processing e.g. list of computer hardware components listed as table in various web...

I have the following code that should open all EXCEL workbooks in a specified path, and unprotoect any password-protected worksheets to allow for Link...

I have 2 worksheets in excel. The first one is imported from my access database. The second is linked to that worksheet. I need to email the second sheet to...

Can anyone direct me to a site or give some direction in linking an access database with excel? I have attempted getting external data - creating a new...

I keep getting a Run-time error 1004 when using Bill Manvilles findlink macro. Any suggestions? -- Message posted via http://www.officekb.com

Hi I have a link in a workbook that is created by a user-defined worksheet function. Typically when I click the link, and then go back to Excel, the workbook...

I am using M$ Excel that I got with Office XP... I am making a Rugby World Cup spreadsheet... With scores, tries scored, total points, and so on.... But I...

A user has recently upgraded from office 2003 to office 2007 on a Windows XP SP2 machine. This user used to receive a spreadsheet from a client via email to...

If anyone can assist, I'd be most grateful. Firstly, Extend Formats & Formulas to Additional Rows is checked in Oprions under the Tools menu. BUT, as well as...

Hi All, Apologies if this has been asked 1000 times already ... I have two Excel files file1.xls file2.xls File1 gets auto-generated each night and...

Hi, I have a problem with my MS Excel 2002 (actually it exists in MS Excel 97 too). Every time I'd associated a hyperlink with the text inside a cell, the...

Hello, Can anyone tell me the best/easiest way to transfer/link data between two Excel files under the following conditions?: -the source file is always...

Hello - We're on Excel 2002 SP3 and use Windows XP. Our database here at my work is HUGE... and incorporates a mixture of names, addresses...etc... plus...

ALL of the postings with attachments you are currently seeing in the Excel newsgroups ALL have viruses -- DO NOT OPEN. Be suspicious of any posting that is ...

I have an Access database that's secured with a .MDW. I can't find a way to reference the MDW file when I try to run a query via the "Get External...

Is there a reason why links within the same workbook will not update automatically especially when excel is set to update links automatically? A linked cell...

Hi. This may have already been asked. I have a column that has an email address in each row. How can I create an email message by clicking on a header that...