I currently use Excel 2007 and I am working on a template with a link to an
Excel database file. For example, C:\China\Template.xlsx (File 1) has links
to a file C:\China\Data.xlsx (File 2). When I open these files together, File
1 is updated with File 2 as it should be. But if I ...

We work on Excel files that link to several datasource files (100+) and when
I try to view the links via Data -> Edit Links, it pops up an "Edit Links"
window that spans the length of the Excel screen and shows a list of only
about half of my links.  The window does not have a ...

Hi. I have another problem with the links. Has anyone resolved a
similar issue?
The problem exists between excel 2002 and 2003.
Users of Office 2003 in order to use the file have to broke all

Is there a way to link a whole range from one workbook to a worksheet in
another workbook?
As it stands with me right now, I have linked cell E4 in wb2 to cell E4
in wb1, but there is a range of approx 8 cols by 52 rows that actually

There is a problem with updating xls files via Outlook. The xls file
was opened in outlook, updated it and saved. But all external links
were changed into internal with path: "C:\Documents and Settings
\xxxxxxx\Local Settings\Temporary Internet Files\OLK89\2846 FQ\

I'm new to this forum and have been checking for solutions, no luck so
far so hope someone can help me out.
I have an access database and I am able to export successfully to excel
using "import external data". When I enter new data into access, it will

I am trying to edit a very simple XLS worksheet that automatically fills
data from a very complex Access database via a MS Query.
The problem is I had to take both the XLS and MDB files to a seperate
computer to edit due to  the Acess database is used 24/7 and I cannot 'take