I have a excel template that has a link to a txt file in the same folder. I would like this link to stay 'local' when the template is 'saved as' a XLS file...

We have a problem with linked cells. We have a main spreadsheet which links to other spreadsheets, the problem is that occassionally the linked cell...

I wish to create a worksheet with a drop down list of tools which i can pick the tools I need and create a list to give to someone to get ready ,this I can do...

You can see on the file samplewrapwrep4.zip Worksheet B of B62, I then typed 15254", it col name "yarn count" and the product code you can see is Q921 at...

I have an excel file that links to several other files in the same directory. Previously, when I made a copy of the entire directory, the links in the new...

I have a five-tab spreadsheet/workbook on which all data entry takes place on tab 1, other tabs contain look-up tables, instructions, etc and the final tab is...

Hello! Can anyone help me figure out how to lock hyperlinks to a text instead of to a cell? I am creating an inventory list (with List Maker) in Office Mac...

Hello folks, I need to link from data in Excel into Word, however, I need to be able to show various lines of data in the link, so sometimes there maybe 10...

G'Day, I'm using an Excel worksheet as a data source for merging into a Word document. Some cells are "formatted" to contain blank lines (entered using...

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'...

Hi all, I have a question about linked cells. Let's say that I have a cell B2 with value 5. I have another cell C4 which I want to display the value of B2 but...

I am trying to set up a macro that will send a fax of the current sheet to a fax number which is a vaule in a cell (i.e E12) I could use MS Fax or Winfax. Any...

We have a need to move a number of spreadsheets that have hundreds of links in each of them and I am wondering if there is a utility that can be used to...

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...

Try out this new excel tutorial which is still under development http://xlmaster.blogspot.com

is there anyway you can see what links to other workbooks are associated with the workbook you have open. The problem i am having is when i open the workbook...

I have a Word document that I want to link up with data from an Excel spreadsheet. For instance, say I have a sentence in a Word document like: Last quarter...

I've been using the same 88 page workbook for about 2 years, in the same way. Today, when I entered any data, it was entered across all 88 pages, on the same...

I have the file path to several files of mine in columb A. In columb B, I use =hyperlink(A1) and copy down. The hyperlinks work fine but I only want to...

Hi There I have a problem that has just started. When I have two or three spreadsheets open if I try to copy off one sheet toanother it says not enough...