Our L:drive has directories, some of which are actually a
department H:drive - so it is possible to go into the same
file via the L: or H: drive - the difference being
a 'department name' as the first part of the string when

I am attempting to consolidate data from weekly workbooks into a single monthly.  I would like to be able to retrieve data from a closed workbook, if the name of the file is typed into a cell.  I envision 4 or 5 cells (one per week) in which the user types the filenames for the ...

Can Excel pull data out of SQL-Server? If so, where can I find documentation
on how this is being done.
Thanks,
Matt

I have inadvertantly created a link from the source file
to a destination file that has now been deleted from the
system. How can I trace in which cell/worksheet of the
source file the link has been created so that I can

I have a sheet that will list certain results from many other sheets, I
would like the link to be dynamic so when I change the value in one cell it
calls a different sheet.
I use names as easier reference

I have my .png files set to open with Irfanview. However when these files
are opened from excel using a hyperlink the file association is not
recognised. No problem with .tiff but would prefer to use .png
Thanks

I have a link in a workbook that is created by a user-defined
worksheet function. Typically when I click the link, and then go back
to Excel, the workbook becomes hidden. Occasionally it works (and if I
remember correctly it used to work all the time).

I have lost the ability to open an xls attachment direct
from OE. When I double click the attachment in OE Excel
opens and I get the error message "Cannot find the file
C:\Windows|TemporaryInternet Files\Content.IE5\4F10KAB7

I'm sure this question has been asked many times in the past, but I haven't
had much luck finding a solution.
Using OLE, where an Excel spreadsheet cell range is the source, is it
possible to specify a directory path as a relative link as opposed to an

I have a customer with a set of rather convoluted mish-mash of spreadsheets,
basically running an entire company.  One spreadsheet  (SSa)  has a number
of links to 4 others (SSb,c,d).  Everything works as expected if SSb,c,d are
open, & then SSa is opened, but if SSa is opened ...

I have a template that I use to eneter data into.  This
template references data from another workbook in the same
folder.  In randon areas when opening my template some
text converts itself into a chinese font making it unable

I've built a multi-tab Excel 2000 spread that links from here to hell and
back. I want to scrap the contents, keep the forms I built, and start fresh
with only one page... the final report. I'll rebuild it backwards.
Is there a way I can void the single report I want in a new ...

Please help!  Is there anyway I can speed up the links on
my Excel workbooks.  One workbook in particular links to
about 15 other workbooks and take ages to recalculate, I
have set it to be a manual recalculation but it still

We are developing a Stock trading VBA Excel application for a client. The client has an Excel workbook that contains a number of DDE links. The workbook also contains a large number of worksheets and data which causes the calculation time to take at least few seconds. My question ...

I've got a problem with formatting changes not updating
in linked document...
Simply put, if you have a document that has a linked cell
to another document, the formatting ie...COLORS doesn't