ERROR - #CALCULATING

PAUL CASTRO

Hola amigos,

Por favor, su ayuda a corregir el siguiente error.

He preparado una hoja maestra a partir de varias hojas utilizando la función VLOOKUP . Estuvo funcionando bien todos estos días, pero ahora en celda se muestra como #CALCULATING se resalta a continuación.

**Translated to English via Google Translate**

Hi friends,

Please, your help to correct the following error.

I have prepared a master sheet from multiple sheets using the VLOOKUP function. It was working fine all these days, but now in cell it shows as #CALCULATING is highlighted below.

¿Cómo puedo solucionar esto?

How can i fix this?

MCorbin

Most likely, you're hitting the Cell reference limit. This happens when the sheet that you're getting the data from has a lot of rows - and/or you've got formulas pulling multiple columns from a large sheet into your summary sheet.

The easiest solution is to break your summary sheet into multiple sheets - let them calculate formulas for just sections of data, then combine them back together using a report.

Here's a little more information on the Cell link limits:

https://help.smartsheet.com/articles/2478811-scc-requirements-guidelines