Is there a way to make the informaition placed in cells dependent on
what is entered in a specific cell?
I have a sheet that I will enter my primary data in with a key cell...I
then want to have a seperate list on another workbook that has cells for

After opening a spreadsheet with DDE links I get the message:
This workbook contains one or more links that cannot be updated.
To change the source of links, or attempt to update values again, click Edit
Links.

I have a small Excel spreadsheet that I am trying to insert as an object in
a Word document. The spreadsheet is about 10 columns wide x 30 rows high.
When I insert this into Word, the object includes more area than I am using
for data. Is there any way to limit or control the area ...

Excel 2003
I want to allow users to choose a month via a validation box and see data
relevant to that month. Other worksheets/workbooks contain the data to be
shown - mostly in ranges of cells. I know I could do it cell by cell with

I have tried and tried to create a DDE link to an application which retrieves
stock prices etc. The basic goal is to have the dde link in a cell, but the
variable (ie stock name) is read from another cell on the worksheet!
is this achievable in Excel.  I can do this by creating ...

I have downloaded the add-in access links and followed all the installation
steps.  When I try to open access form in excel it says there was an error
and it could not open.  Has anyone else encountered this?
Second question:  I wanted to use this to create a form for a worksheet ...

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 restored
folder ...  is there a way to get the links to point to the correct path vs
the restore path?  

Have 1 MASTER excel file that needs to be "moved" from it's current
location.
Have many WORKSHEET excel files that are linked to that master for updating.
How can I update ALL worksheet excel files with the new location of the

I have trying to auto-publish data from spreadsheet to a HTML file.
I have created a spreadsheet which MS Scheduler automatically opens.
Within the spreadsheet is an Auto_Open macro, which:-
Refreshes data within a pivot  extracted from a third party application,

I have two worksheets in a workbook to store data about my CD collection;
one is alphabetical and one chronological (based on purchase date).
How do I link the sheets so that when I enter data about additions to the
collection in the chronological sheet the alphabetical sheet ...

I am trying to set up a sheet to access stock quotes. I know the site and
table, but I want to list a column of stock codes from which a web query
grabs the code and runs to download the stock quote. I know how to select the
parameters for a conventional query, but can anyone ...

Is there a way to programmatically access links and change them in VBA?
Specifically, we're doing a migration and want to be able to change names of
the links in a spreadsheet from .123 to .xls (converting the source files,
then go back to the destination file and change all the ...

I have a worksheet with lots of formulas. Some of these
formulas are linked to other workbooks in the same
directory. Is there a way I can identify all the links
without having to check all the formulas? Thanks for your

I am running Excel out of Microsoft Office Pro 2003 under
Windows XP professional on a Dell PC.
When I open a new spreadsheet / workbook, and type in an
even number, the cells show no decimals.  I would like the

Is it possible to convert an excel-file with formulas to a pdf-file
(Acrobat) and still be able to run calculations (in the pdf.file)?
Jorgen