AOO 4.1.5 on DELL desktop; WIN10 Home x64
_________________________________________________________
I don't know or understand how update Links, or update Styles, is
supposed to work in Calc.
Each time a Calc file is opened, I am prompted for a Yes/No to up date
All Links, or sometimes Y/N to update New Styles.
In an opened Calc file I have selected a cell and pointed to a specific
cell that is located in a different Calc file.
( e.g., entered in the cell:
=('file:///C:/Users/Username/Documents/...../....filename.ods'#$'sheetname...'.J79
).
This is no longer working in several Calc files ( "0" value is returned
rather than the expected value contained within the external file &
Cell). But, this /pointing to an external file's cell/ does work in a
New Calc file, when pointing to the same external file sheet & cell.
I hope that somebody can point me in the direction of or give me a
description of how this is suppose to work, and perhaps enlighten me on
the possibilities of why it is no longer working for several of my
existing Calc files.
In addition, I would appreciate receiving hints about the Update/Use Old
Styles template prompts.
TNX.
Regards,
VinceB.