I have a 23Mb Spreadsheet which has links to various other sheets and
PowerPoint Presentations. When I select certain sheets to create a copy, the
following occurs
1. Book 1.xls created

I have two sheets in my workbook.
One has a listing of table headers like:
BOBSTABLE01 - Test for Usenet Help (Cell A1, Sheet 1)
The second sheet contains the same header followed by details of the

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
refrence is lost and the cells are replace by #ref.
Can anyone help please.

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 cell A62 is same row 62.
Worksheet A, you can see F2 is Q921, col name is "product code".

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
directory would refer to the files in the new directory.  However, today when
I copy an entire directory, the files in the ...

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 the data storage area.
Each tab/sheet is protected with only the data entry cells unlocked.
Only the first tab/sheet has ...

Can anyone help me figure out how to lock hyperlinks to a text instea
of to a cell?  I am creating an inventory list (with List Maker) i
Office Mac 2004 Excel.  I need to link the name of the product (i
Column A) to another Excel sheet with details about the product.  Th

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 lines
of Data in the Excel spreadsheet, but other times there maybe 15 lines of
data.

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 Alt-Enter) to act as paragraph separators. During the merge these
blank lines appear to be removed. E.g.

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' drive. I have created links to various Access databases for which they
auto update when I open the Excel spreadsheets. However ...

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 also be able to change its value if I enter in a new value.
I'm pretty sure it's not possible, but I thought I should ask people

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
re-establish the links if the correct information is given.
Thanks in advance.

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 in question a message
appears and states "The workbook you opened contains automatic links to

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 the foreclosure rate fell by ____ basis points to ____ percent.
I want to fill in the blanks by using specific cells in a ...

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 line that I originally entered it.  Unfortunately, I didn't notice
it until I had already saved a few times.  How do I stop ...