Twist to eliminating the "Do you want to save..." prompt
 

Hi all,

I have various workbooks, which are prepared and utilized by co-workers,
that are hyperlinked into my workbook. I would like to be able to open and
refer to these hyperlinked files while giving a presentation of the data in
my own excel file, but then not be prompted with the "Do you want to save the
changes..." (even though I have made none) each time I click "x" to close
and return to my own file's window.

Is there programming that I can add to my own Excel file (or computer) to
eliminate this save prompt? I want to avoid making modifications in each and
every co-workers files, for fear that doing so could potentially disrupt,
cause lose of data or confusion in the way my various co-workers go about
saving, closing or exiting their files. Again I am accessing these files
through hyperlinks during my presentation , not a macro.

TIA!!!
Tanya

Twist to eliminating the "Do you want to save..." prompt
 

Hi, in my opinion, try using the hyperlinked files in read-only mode. I guess
that should solve your problem.

"JustBreathe" wrote:

Hi all,

I have various workbooks, which are prepared and utilized by co-workers,
that are hyperlinked into my workbook. I would like to be able to open and
refer to these hyperlinked files while giving a presentation of the data in
my own excel file, but then not be prompted with the "Do you want to save the
changes..." (even though I have made none) each time I click "x" to close
and return to my own file's window.

Is there programming that I can add to my own Excel file (or computer) to
eliminate this save prompt? I want to avoid making modifications in each and
every co-workers files, for fear that doing so could potentially disrupt,
cause lose of data or confusion in the way my various co-workers go about
saving, closing or exiting their files. Again I am accessing these files
through hyperlinks during my presentation , not a macro.

TIA!!!
Tanya