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.



Reply via email to