Excel forumla longer than 8192 characters

Question

I have a Excel worksheet that is 5490 columns wide in a shared workbook. When I save the file with zero columns hidden I do NOT get this message. When I hide every 11-15th columns it will work until I get to column 4245 approximately. After that I get the formula longer than 8192 characters. I do NOT have any data in any of the "hidden columns". Any feedback on how to fix this issue would be greatly appreciated.

Answer 1

Hi @Josh Albers

Did you run any macro to hide the columns?

Is there any reference of another workbook in the formula, or Data Consolidation references. In this case, please check full pathname of that workbook.

Did you use "Name" function? You may check the named ranges.

Here is a similar thread: Share Workbook Error - Exceed 8192 char in formula, you can refer to it to see if you have more ideas.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---