Linking to word document
Tue, 22 Jul 2008 11:17:07 -0700 (PDT)
Hi - I know this is an Access question in an excel group, but I'm not
sure the Access group is active (I've posted this question there). I
am just teaching myself Access and have a quick question: when you
have a table (like an excel spreadsheet), can you link a cell to a
word document? I ask this because I a ...
|
Error message #N/A appears in linked cells
Wed, 16 Jul 2008 12:30:08 -0700
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 link
results. Some cells display #N/A and some cells are fine. The formulas are
the same, except they refer to a cell in a different row. When I open the ...
|
Hyperlink change after email...
Wed, 16 Jul 2008 06:34:01 -0700
Hello.
I have an excel sheet that has hyperlinks to other sheets. All sheets are on
a network share and permissoins are open to all.
When I attach and email the excel sheet (that contains the hyperlinks) from
the network share, the recipient receives the sheet and opens it, the
hyperlinks have all been cha ...
|
Hyperlinks and sorting
Tue, 8 Jul 2008 12:59:00 -0700
Can you lock a column that your hyperlinks are in so that when the user sorts
the data that column does not sort?
--
Xena ...
|
Hyperlink - How to copy
Tue, 8 Jul 2008 12:06:21 -0700
I am trying to copy a hyper link down 300 rows in a document. I was hoping
as I drag down the cell that it is hyperlinked to would change just as if I
were copying. How can I change the designated cell in the hyperlink without
having to enter it 300 times.
Thanks
--
Xena ...
|
Links between workbooks
Tue, 8 Jul 2008 11:21:04 -0700
Is there a way to maintain a link(s) between workbooks contained within
sub-folders of a master folder when you copy the master folder? Right now all
the links refer back to the workbook in the copied folder.
--
JimD ...
|
get external data doesn't pull all data
Mon, 7 Jul 2008 19:45:01 -0700
I am trying to access a SQL database (MS CRM 4.0) using the Connections
feature in Excel 2007. I am able to connect to various tables and views,
however, some key columns of data do not appear. I am wondering if they are
hidden or I have a security issue. If I try to access the data using SQL
Server BI 20 ...
|
|
|
Creating a mail link
Tue, 01 Jul 2008 19:50:37 GMT
Hello,
I am looking to create a mailto: link in an Excel spread sheet that puts the
date of the form as part of the subject.
eg: Subject: Sales for 7/1/2008
The "Sales for" would always be the same but the date would be taken from
the top of the form.
As a note, our business day extends past midnight, so ...
|
File directory structure reorg
Tue, 1 Jul 2008 10:36:09 -0700
One of our departments wish to rationalise their directory structures, which
overtime has become a bit of a mess. They have numerous files across this
existing structure that have links to other files elsewhere in the structure.
Their wish is to move all of these into the new structure, but I understand
d ...
|
Automatic update multiple files
Tue, 01 Jul 2008 16:07:32 GMT
Hi,
I have a folder with multiple excel reports from different people providing
data from different areas using the same chart format.
there is multiple data sections and dynamic charts in each file.
every month, the data in each chart has to be moved one cell over for the
next data to be seen on the chart. d ...
|
