In my workbook, I must have as many sheets as there are days in a
month.  In each sheet I have about 20 tables filled with different
types of data: text, dates, currency, etc.  The entire workbook then
contains a month of daily data.

Excel Gurus:
I have some named cells in a worksheet. In another worksheet I have
hyperlinks that refer to those named cells. When I sort the worksheet with
the named cells the hyperlinks on the other sheet don't follow the named

Hi Everyone (especially Bill Manville),
I have been asked to investgate an issue with Excell and hyperlinks. I will
try and explain the scenraio..
There is an .xls file on a server called contracts.xls . The UNC path to the

I have the following situation:
1 Folder that contains 10 WBs + 1 WB for consolidation
The folder is located under \\home share\FolderName\...
Now, so far no problem at all, every week, I can update the consolidation WB

I have 2 computers. Computer XP uses Windows XP and Computer 98 uses Windows
98.
I dabble in programming (Microsoft Visual Basic, Learning Edition).
I have installed some of my programs on both computers. Most of these

We are using a workbook for our payroll.  The file has aheet with every
employee's name plus a summary page.  The file is 5.67MB.  The summary page
is linked to each employee sheet. The summary page has 7 rows for each
employee that is linked to the emplyee's sheet.  If you move ...

I keep getting a Run-time error 1004 when using Bill Manvilles findlink macro.  Any suggestions?

How can I show the choice from a drop down list in one worksheet in a
specific cell in another worksheet?
Any suggestions? Thanks.

How do I link two workbooks in Excel 2000 so that I can link two cells; one
in one workbook and the other in another workbook?
Thanks,
Jig.

      I have a list of clients information stored in MS access. When i use
MS Excel and as i type in the name of my client, my clients other information
like address, tel no, fax no and all will appear. How do i go about doing it.
I have installed Microsoft Accesslinks Add-in but ...

- Excel 2000 w/latest patches from Office Update
- Win2K and WinXP and W2KServer and W2003Server
When we enter Hyperlinks to a file in Excel and the target is on a mapped
drive (s:\ mapped to \\servername\sharname\worddoc.doc) Excel converts this

I developed one excel file in Office XP. It is linked with 6 files, it
contents around 2500 linked cells. If I try to open the file from the excel
with version lower then HP, illegal operation message shows and program
falls. Also I get run time error when I try to use findlink ...

I think this one is probably very easy .... but I can't work it out myself!
I have an "old but complex" spreadsheet that I have updated. It works fine
but it links information from an old spreadsheet that does not exist anymore.
The thing is that I cannot find the link anywhere in ...

I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway??????  This only happens on 2 out of 20 pc's and I cannot figure ...

When I send an Excel workbook as an attachment the source of the links
(links are to another excel sheet on a networked drive) defaults to
C:\ (but maintains the same network reference) when the sheet is
opened from within Outlook.