I've created a spreadsheet that use internet hyperlinks. When the spreadsheet is sorted, the text moves but the hyperlinks stay where they are. Is there any...

Hello, I have inherited a bunch of data, that is named under different folders however the information inside the folders are the same. In other words I have...

Hello, We have a Word document with approx 90 fields linked to an Excel workbook. What we're trying to do is have an Excel VBA procedure step through a table...

Hi everyone. I'm going crazy here. I have a Master Excel file with a bunch of hyperlinks. Some links go to other spreadsheets in that file, some go to...

Morning all. Once again I am stupmed after trying something a little different this time. I am trying to hyperlink a DWF file in Excel and while the...

I have a small website that uses files from a web development package, Word docs and Excel spreadsheets saved in htm files. I link from one to the other but...

Well, I have a problem. My open workbook is Named "One.xls" My closed workbook is Named "ClosedBook.xls" This "ClosedBook" is located as indicated in...

Hello, I'm using Excel 2003 and have files with lots of links. Cells are linked to an external workbook. The cells in the same column have inconsistent...

When I open a file with links to another file, a security warning shows in the message bar showing that automatic update of links has been disabled. When I...

I currently use Excel 2007 and I am working on a template with a link to an Excel database file. For example, C:\China\Template.xlsx (File 1) has links to a...

I have a Command Button on a worksheet that I only want to display if a specified User Opens the workbook. I have the following code: (in a UserName...

Ii have an excel file that was corrupted and restored and now that i placed it back in the original folder 100's of links are wrong and point to...

Hi, I am trying to export an excel worksheet to word, but want to be able to allow a user to update info. in excel and it automatically updates in word. I...

I have a spreadsheet with a bank of index buttons at the top that are linked to separate series of data blocks listed below. The panes are frozen right below...

I have a spreadsheet that uses ODBC/MS Query to connect to a database and pull in part numbers each time the worksheet is opened the file refreshes. The part...

I have dual monitors in which I open two different worksheets. When I try to link from the worksheet on monitor 1 to the worksheet on monitor 2, it will not...

Hello How to go back to last selected cells?

Hello How to replace column letter(s) (or column numbers) in refferences with a result of a function using the old column letter(s) (or column numbers)?

I have a number of Excel files on a network server which it is mapped on my PC as the 'H' drive, however for some users this drive is mapped as their 'K'...

Hello, I have several excel spreadsheets linked to an ms access database. The excel spreadsheets needs to be updated prior running the access database so it...