Ask Your Question
0

How do I force recalculate on value in cell which references another spreadsheet file?

asked 2019-01-26 13:27:49 +0100

WestNab gravatar image

Value in cell is of the form: ='file:///Users/xxx/Documents/foo.ods'#$'Sheet1'.A1 If I change the value in foo.ods, Sheet1, cell A1, then the cell does not update. If I save the file, it doesn't update. There is an answer from 2015, but there is apparently no longer a 'Cell contents' option on the Tool menu which the answer mentions. F9 or Ctr-Shift-F9 was keyboard shortcut apparently - isn't any more.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-26 22:07:52 +0100

erAck gravatar image

F9 (on a cell or when automatic recalculation is disabled) or Shift+Ctrl+F9 recalculate formulas with the current spreadsheet data, including cached values from external sources. They do not (and did not) reload data from external sources. To update external data go to Edit -> Links to External Files..., select the data source(s) you want to update and click Update.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-26 13:27:49 +0100

Seen: 49 times

Last updated: Jan 26