LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
BRB BRB is offline
external usenet poster
 
Posts: 23
Default Formula too long problem

I've received a file from a colleague in France with a very long equation in
several cells. Actually it just adds 14 cells together, but since the cells
are in other workbooks the cell name is very long. Here is the problem. He
has no problems seeing the entire equation (i've seen it via netmeeting) and
can therefore edit it. I'm in the US and cannot see the entire equation,
therefore, I cannot edit it. If I tried to add to the portion of the equation
I am able to see I get a window saying "Formula too long".
Is there a setting I can change to be able to see the entire equation and be
able to edit it? Thanks,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Problem with Concatenate - Results are too long for CSV DrewPaik Excel Worksheet Functions 4 June 24th 08 08:49 PM
Clearing cells takes long, long time unclemuffin Excel Discussion (Misc queries) 9 August 17th 07 02:22 AM
formula too long! phil2006 Excel Discussion (Misc queries) 8 July 2nd 06 11:34 PM
Formula too long problem rfritz Excel Discussion (Misc queries) 2 June 9th 06 06:16 PM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM


All times are GMT +1. The time now is 12:26 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"