Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel error: formula too long (Read 5167 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel error: formula too long
14.03.07 at 11:42:23
 
Excel error: formula too long
 
SQL*XL user Helmut ran into the following problem with the SQLQueryValue SQL*XL UDF.
 
Any formula in Excel cannot exceed the length of 255 characters. There are workarounds. The easiest one is to put the SQL in a cell somewhere. You can put many more characters in a cell. Then use the cell address as SQL. E.g. if you put your SQL in Z1 you can use =SQLQueryValue(Z1)
Back to top
« Last Edit: 14.03.07 at 11:46:21 by Gerrit-Jan Linker »  

formula_too_long_001.gif

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1