I have DDE server providing information to Excel.
After upgrading to Excel 2002 & Windows XP from Excel 2000
& Windows 2000 I started experiensing sevier performance
degradation. A spreadsheet that take about 2-3 min to

I am looking for a way to link data between sheets/files, so that when
I create a new column in Sheet1, this change is reflected in Sheet2.
Sheet1:
Header1    Header2    Header3

How do you paste link data aswell as transpose it when
paste special?  It wont allow you do to do both on the
paste special function.

Using VB6, I have created an excel spreadsheet. Some cells contain a
hyperlink to TIF image files on a specific server within the LAN. When the
user clicks on any one of these cells, it launches a copy of Imaging
software and displays the image the hyperlink is pointing to.

I reposted due to my last message was deleted or something?
Excel 2000
Hello,
I need to read cell values from a closed Excel file into an array which is

We have recently upgraded from Office 2000 to Office 2003.  When opening an  Excel workbook in Excel 2003 (document created when we were using Excel 2000) and adding a new worksheet (eg summary sheet), and creating links through to cells on other sheets within the workbook, the ...

Hi! Can anyone help.
At the moment I am working on a Workbook which involves
measuring performance within an organisation.
There are 7 areas of measurement and 6 Geographical

You may download the free books and software from
http://www.vgupta.com (offer good till Dec 31 2003)
Excel For Beginners
Charting in Excel

Microsoft Sharepoint Portal Server 2001 SP1
Microsoft Excel 2002 (10.3506.3501) SP-1
Links need to inserted into an cell in a file that is stored in Sharepoint
pointing to a folder on the Sharepoint server.

Hi. This may have already been asked. I have a column
that has an email address in each row. How can I create
an email message by clicking on a header that will
include all emails in the individual rows? Keeping in

Please Help me ! I have a problem ...
I linked the cell "A10" of 30 workbooks to the cell "A10" (Value =
25%) of the workbook we'll call "Master", so I can change the value
for 30 workbooks in one time.

I have a very large workbook, containing c.90 sheets and
numerous macros.  Each time the workbook is opened I am
asked whether to update links.  If I answer "yes", I get 2
File Not Found messages, one for each of two files.  

I need to know how to link one or two fields in Excel so that
the info in the primary worksheet is automatically copied into
the second worksheet.
Unfortunately, I don't have a book on Excel! I'd appreciate any

I have an excel spreadsheet that references numerous other
spreadsheets via hyperlinks. The problem is the xls was
designed with the supporting spreadsheets in a defined
structure, i.e. c:\work\2003\stuff\stuff.xls

I have a workbook with many sheets in it.  I've done many updates to the
file including making copies of sheets w/ links to other worksheets within
the workbook, as well as renaming the file numerous times (e.g v2, v3,
etc.).  Now, each time I open the file, it asks to update ...