Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Formula too Long
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 4
Default Formula too Long
I have the following formula in one of my excel cell and I would like
to link other files to this formula but I get a message saying "formula
is too long." What can I do to work around that? Please advise!
P.S. I would like to do this e/o all necessary files open if possible.

=+'W:\IB EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[TL NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
NII Files\Legacy\[Nelico NII Proj 2006-07-25.xls]iEC
Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
Files\Legacy\[MLIG NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[MLFS+MMA NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
NII Files\Legacy\[GenAm NII Proj 2006-07-25.xls]iEC
Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
Files\Legacy\[MoRe NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[Exeter NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'[CLIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[FLIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[MVATIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[TIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[MVATLAC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,440
Default Formula too Long
Hi Chuck,

Why not have a table with simple formulas like

='W:\IB EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[TL NII Proj 2006-07-25.xls]iEC Adjustments'!C5
='W:\IB EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[Nelico NII Proj 2006-07-25.xls]iEC Adjustments'!C5

etc and one SUM formula to add all these?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chuck" wrote in message ups.com...
|I have the following formula in one of my excel cell and I would like
| to link other files to this formula but I get a message saying "formula
| is too long." What can I do to work around that? Please advise!
| P.S. I would like to do this e/o all necessary files open if possible.
|
| =+'W:\IB EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[TL NII Proj
| 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
| NII Files\Legacy\[Nelico NII Proj 2006-07-25.xls]iEC
| Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
| Files\Legacy\[MLIG NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
| EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[MLFS+MMA NII Proj
| 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
| NII Files\Legacy\[GenAm NII Proj 2006-07-25.xls]iEC
| Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
| Files\Legacy\[MoRe NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
| EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[Exeter NII Proj
| 2006-07-25.xls]iEC Adjustments'!C5+'[CLIC NII Proj 2006-07-25.xls]iEC
| Adjustments'!$C$5+'[FLIC NII Proj 2006-07-25.xls]iEC
| Adjustments'!$C$5+'[MVATIC NII Proj 2006-07-25.xls]iEC
| Adjustments'!$C$5+'[TIC NII Proj 2006-07-25.xls]iEC
| Adjustments'!$C$5+'[MVATLAC NII Proj 2006-07-25.xls]iEC
| Adjustments'!$C$5
|


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 6,953
Default Formula too Long
formula are limited to 1024 characters when expressed in R1C1 notation.

so you can physically move you directory closer to the root,
Rename directories, files and sheets with shorter names

or

You could created defined names (insert=Name=define) that refer to the
cells, then use those defined names in your formulas

--
Regards,
Tom Ogilvy

"Chuck" wrote:

I have the following formula in one of my excel cell and I would like
to link other files to this formula but I get a message saying "formula
is too long." What can I do to work around that? Please advise!
P.S. I would like to do this e/o all necessary files open if possible.

=+'W:\IB EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[TL NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
NII Files\Legacy\[Nelico NII Proj 2006-07-25.xls]iEC
Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
Files\Legacy\[MLIG NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[MLFS+MMA NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised
NII Files\Legacy\[GenAm NII Proj 2006-07-25.xls]iEC
Adjustments'!C5+'W:\IB EBS\2006-08-04 P\NII\Revised NII
Files\Legacy\[MoRe NII Proj 2006-07-25.xls]iEC Adjustments'!C5+'W:\IB
EBS\2006-08-04 P\NII\Revised NII Files\Legacy\[Exeter NII Proj
2006-07-25.xls]iEC Adjustments'!C5+'[CLIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[FLIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[MVATIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[TIC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5+'[MVATLAC NII Proj 2006-07-25.xls]iEC
Adjustments'!$C$5


Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo Max Loger Excel Discussion (Misc queries) 0 June 14th 11 04:30 PM
Formula is to long RKS Excel Discussion (Misc queries) 8 March 3rd 10 08:44 AM
Long Long Long Nested If Function sed Excel Discussion (Misc queries) 4 December 9th 09 06:44 PM
formula too long cencoit Excel Worksheet Functions 3 September 22nd 05 02:26 AM
"Formula is too long" gobonniego Excel Worksheet Functions 1 August 3rd 05 09:48 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement