# Changed entries to #REF!

How do I get my figures back from #REF! ?

First time here? Check out the FAQ!

Changed entries to #REF!

How do I get my figures back from #REF! ?

3

Hello,

no one can answer that since `#REF!`

means you referenced to some unknown/incorrect address (probably by copying a formula containing a relative address to a new cell and the re-calculation of the new address would result in an address outside of calc's address space). Example: Type `=A1`

into cell `B1`

and delete column `A`

=> you get `#REF!`

in new cell `A1`

- nobody can determine what has been in `B1`

before you deleted column `A`

Asked: ** 2020-11-19 17:01:08 +0200 **

Seen: **48 times**

Last updated: **Nov 20 '20**

arabic language support [closed]

Libreoffice math. no IME. Cannot edit formulas. [closed]

How can I get better quality in Math GIF images for HTML exports? [closed]

Can I export a document to LaTeX? [closed]

What could prevent the small formula window from working in LibO 3.5? [closed]

MATH The application does not appear below the edit window. [closed]

Del Operator in Libreoffice Math [closed]

is there something like quickbooks in libre office? [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

This question is related to

calcand not tomath(which is the formula editor of LibreOffice). Please retagEdityour question to explain why you consider it related to the mathematics formula editor, a companion application of Writer.In case, your question is about an error in a spreadsheet,

retagto replace`math`

by`calc`

. Press`Enter`

twice to exit retag mode.Anyway,

edityour question to explain your context (in which circumstances #REF! appeared) and mention your OS and LO version. Otherwise your chances to get an answer are quite low. Read these guidelines and follow them.And maybe file format used to save it's relevant.