Excel 97 freezes up when using hyperlink to another excel rpt file

J

JP

When preparing a hyperlink report (a report that uses hyperlinks to connect
to various other reports within Excel) so that there is only one place a mgr
can go to find numerous reports, I found that it works EXCEPT when someone is
using one of the reports being hyperlinked to. When that occurs, a message
comes up that "John Smith is using the file..." and an option to CANCEL or
READ ONLY...if you choose either option, EXCEL LOCKS UP and the hour glass
stays running...at which point I have needed to totally exit out of EXCEL in
order to use the program again. Any ways around this? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel hyperlink to another open Excel file - wants to reopen file 1
Print hyperlink when saving to PDF 0
Print hyperlink when saving to PDF. 1
Trouble with permissions to shared excel files when using import q 0
Dsum and Dmax with structured references 1
Excel 2003 - hyperlink to a location in the same file 1
Trouble opening hyperlinks to shared folder 4
No program is registered to open this file 1

Top