|
|
Invalid Names by
Steve
I've tried deleting links via the Links Dialogue and the Defined Names
windows and I 've tried using code to delete the names. But my code returns
an error...
|
July 28th, 2006 03:29 PM
by Steve
|
5 |
258 |
|
|
Source not found by
Derek Dowle
Excel 2003 SP2
The problem relates to a workbook not being able to access data in a linked
workbook that resides in a different sub-directory.
I have five...
|
|
0 |
203 |
|
|
links to hyperlinks not working by
Rohan
Hi,
I have a excel which stores URL and its short description.
I need to have a cell in other excel to have the "short description"
from first excel and when...
|
July 25th, 2006 03:10 PM
by Rohan
|
0 |
177 |
|
|
Excel Addin for Access Links by
Jim Normile
I now use Excel 2003. BAck in Excel 2000 there was an add-in "Access Links"
which allowed conversion of Excel Listfile data to an Access table. I cant
find...
|
|
1 |
194 |
|
|
Unable to Read File by
steenman2
I am having a problem linking one workbook to another. Let me lay it
out...
I ahve a database that runs a query and then uses a macro to "Output
to" the query...
|
|
1 |
168 |
|
|
|
|
0 |
196 |
|
|
External Query Definition Disappears by
Mel Lewis
I use many external database queries in my worksheets. To refresh results, I
simply right click in the data and select Refresh. Sometimes, however, after
the...
|
|
0 |
170 |
|
|
Trouble Updating Linked Spreadsheets by
Susan Ellis
I am working on 2 Excel files with multiple tabs and spreadsheets going out
to Col. EU. I don't have any problem when I am working on these files at my
home...
|
|
2 |
215 |
|
|
Excel Queries by
Anselmo
I created an excell file, and I am refreshing the excell queries using
ActiveWorkbook.RefreshAll function, but everytime I need to enter the
username and...
|
|
4 |
306 |
|
|
Running Macros by
I have the following Macro (which I need to run on approximately 200
different workbooks) -- what is the BEST way to achieve this? Should I use
a Function...
|
|
3 |
509 |
|
|
|
|
1 |
253 |
|
|
|
|
0 |
190 |
|
|
linking data in excel and access by
John V
I am trying to look up a reference value in a excel worksheet cell in an
access database to display, in excel, a value related to that reference.
i.e. enter a...
|
July 12th, 2006 05:41 PM
by John V
|
2 |
193 |
|
|
Excel/ Outlook embedding or link by
Martin
Hello folks.
I need to link or embed the value of a single cell in excel into an html
email in an outlook public folder.
The value of the cell contents will...
|
July 12th, 2006 02:20 PM
by Anselmo
|
2 |
233 |
|
|
|
July 10th, 2006 09:05 AM
by CTS
|
1 |
179 |
|
|
Problems saving a worksheet with links by
Does anyone know how I can resolve this issue ... I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet)...
|
|
1 |
457 |
|
|
|
July 6th, 2006 02:07 PM
by
|
1 |
460 |
|
|
|
July 5th, 2006 11:11 PM
by
|
0 |
432 |
|
|
Updating Linked data in Excel by
Does anyone know the best approach for this?
I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional
spreadsheets which have ODBC links to various...
|
July 5th, 2006 09:01 PM
by
|
0 |
416 |
|
|
|
|
3 |
274 |