Hi,
We are working on designing some fairly complex weekly financial reporting for some clients, with actuals, budgets, and forecasts.
In our design of the financials we know that we are limited by 16 sheets (tabs).
Some of our formulas with querysheets are over 300 characters long because we know with the digit location of some of our syntax errors. We expect there could be some formulas as many as 600 or more characters but we haven't got there yet.

Is there a known limitation formula length?

Thanks, in advance.
Brian

Hi Brian,

Sorry for the delay, took a while to look up the actual limits.

An individual formula cannot exceed 16K characters or 100 function calls.

Hopefully that will be sufficient to meet your client needs!

Thanks,
Brian