W
Wellie
I have a Masterspreadsheet that collect data and results from a set of
spreadsheets thru the use of hyperlinks. I found that sometimes, in the
master spreadsheet, some of the values of cells where the hyperlinks are
supposed to brin in the values do not work. The cells show "N/A" instead of
the expected results (values from the linked spreadsheet). However, as soon
as I open the linked spreadsheet which the hyperlink is supposed to bring in
the value, the cells in the Masterspreadsheet are then automatically updated
with the correct value.
This does not happen all the time.
Can someone please tell me what I have to do to correct this problem ?
Regards
spreadsheets thru the use of hyperlinks. I found that sometimes, in the
master spreadsheet, some of the values of cells where the hyperlinks are
supposed to brin in the values do not work. The cells show "N/A" instead of
the expected results (values from the linked spreadsheet). However, as soon
as I open the linked spreadsheet which the hyperlink is supposed to bring in
the value, the cells in the Masterspreadsheet are then automatically updated
with the correct value.
This does not happen all the time.
Can someone please tell me what I have to do to correct this problem ?
Regards