Spreadsheet cell announces Error:540 no matter what

English
#1

Error 540; Calc 7.2.3.2; Ubuntu using Mate desktop.

This just popped up recently. I have 5 spreadsheets (SS) that I import data from into my main SS whenever it’s opened. Now, when I open the main SS, BEFORE I click on the annoying “Automatic updates has been disabled” button that won’t go away, there are 3 CELLs which don’t show any data. Just a $.

AFTER I click on the “Allow updating” button, ONE of those cells changes to “Error:540”. None of the other imported cells do that. They stay with the $. All of those SS’s are in the same folder.

Nothing I’ve done fixes it. Next time I open the SS, and click on Allow, that single cell changes to Error:540.

What do I do to solve this?

Thanks.

#2

Here is a list of the error codes.
Maybe it can help you.

Error Codes in LibreOffice Calc

#3

Try this (warning: The suggested setting may conceivably pose a security threat if you receive spreadsheet files from insecure sources):

  • Menu item Tools - Options
  • Expand branch LibreOffice Calc - General
  • Under heading Update links … select Always …
    If the option was originally set to “Never”, try raising it to “Ask …” first.
#4

Thanks for looking at this.

The action above didn’t change it. Still gives Err:540

#5

For that Always (from trusted locations) setting to work, make sure that the directory containing the document that has external references is added to the trusted locations, Tools → Options → LibreOffice → Security, Macro Security, tab Trusted Sources, Trusted File Locations.

#6

I had high hopes for this one as when I got to the Trusted Sources tab, it showed last years folder but not this years…so I added this years folder…

BUT…same problem. I would open the SS and the cell in question had the right $ amount. Then I’d click on the Allow Updating button and it would revert to the ERR:540 message.

So, this idea didn’t fix the problem. But I found a cure, see below.

#7

What I did to cure this problem was to DELETE the SS and then recreate it. When I opened the main SS and added the links to the problematic cell, and then Saved, Closed, Opened, clicked on Allow…; it worked finally and showed the correct amount in the cell.

So I guess this was somehow related to the page where I was collecting the data, though I couldn’t tell how it was any different from the sheets where I collect data but this didn’t happen. Weird. All these sheets are copies of the year before going back to '04, where I’m basically just adding a year, doing a copy of the previous page and pasting it into the new year, changing all the dates, then saving the entire SS to a new years folder. How that process caused ONE CELL to be weird is beyond my pay scale.

So this one has been cured…though I’d not call it a FIX.

Thanks for the help.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.