G
Guest
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
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