A
A
Andua2020-11-02 20:21:37
Google Sheets
Andua, 2020-11-02 20:21:37

Can I make a site active without my knowledge?

There is a google spreadsheet. When you shut down a site, everything on the site stops.
Is it possible to make the table work after the exit or when the site is down.

{The reason for the long loading of formulas. Yes, I know what needs to be deleted, divided, and so on. But these are not my options. }

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-11-02
@ProgrammerForever

What's the problem? The data will not be updated until it is needed. And when needed, they will be updated.
And in order not to slow down - optimize the table:

  • read frequently used values ​​in a separate place
  • remove unused columns and rows
  • if some data is not needed often, but it is considered for a long time - turn off the sheet or range with a checkmark
    =ЕСЛИ(A2;"";ваша_формула)
    , where A2 - checkbox " Read this sheet "
  • tame conditional formatting and other "whistles", maybe it's not so important
  • etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question