Hyperlink problem with excel

[kjseever]

Here's another Excel problem that has us stumped.

One of our users has an excel document with a hyperlink to another excel document. When you click the hyperlink the file opens but gives the error "Cannot open Template Wizard." When you click Ok it goes ahead and opens, but now it you try to save the file it says "Document not saved."

He also has a macro that when you click on the button it updates a field with the current date and time. If you try to click this it Dr. Watson's with:
EXCEL.exe Exception: access violation (0xc0000005),
Address: 0x3047ccc2

We are using Excel 97 on Windows NT 4.0.

Thanks in advance for any help,

Kenny

 

[xlhelp]

Hi, Kenny!

Will you please e-mail me Dr. Watson log?

Thanks.

Indu

xlwrdhlp@clarica.com

 

[JVFriederick]

Sounds like a contaminated file with the second file.

What happens when you open the second file without using the hyperlink?

You might try to create a new link to another file (that opens "cleanly) and see if you get the same error.

 

[kjseever]

Both files work fine independently. I'm not exactly sure how it is written but the first sheet acts as a database and the second sheet pulls information from it. He said that when he added the hyperlinks they worked fine until he resorted the items in the list. That was when the error messages started coming up.

Thanks,

Kenny