ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "formula too long" error message (https://www.excelbanter.com/excel-discussion-misc-queries/3715-%22formula-too-long%22-error-message.html)

lbaskin

"formula too long" error message
 
i get the above error message when i try to change a source link. what does
it mean and how do i correct it?
thanks

Dave Peterson

A formula can be 1024 characters long (when measured in R1C1 reference style).

Try moving your workbook to a folder that has an overall smaller length:

c:\my documents\excel\for work\January\2005\important_do_not_delay

to
C:\a



lbaskin wrote:

i get the above error message when i try to change a source link. what does
it mean and how do i correct it?
thanks


--

Dave Peterson


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com