Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Linked workbook - "formula too long"

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft+excel+training - Linked workbook - "formula too long"

Resolved · Low Priority · Version Standard

Reply Fri 21 Sep 2007, 14:15Delegate Cameron said...

Cameron has attended:
No courses

Linked workbook - "formula too long"

I'm using Excel 2002 (10.4524.4219)SP-2 and have a number of workbooks with multiple worksheets, all in a similar generic format. All behave perfectly when linked to other workbooks apart from one.

I need to change the source to this spreadsheet and am using Edt / edit links / change source but when I browse to the new file and double click I get the error message "formula is too long".

This is a fatal error, Excel locks, so have to use cntrl_alt_del and then end task from task manager.

Any hints?

many thanks, Cameron

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Sep 2007, 14:44Trainer Richard said...

RE: linked workbook - "formula too long"

Hi Cameron

There is a limit to the length of formulas in excel. 1024 characters. If any of your formulas are longer, this mmight be causing the issue.

Regards

Richard

Excel articles

· How To Ensure You Always Make A Complete Data Recovery
· A Hidden Gem In Excel - Formula Auditing
· Going Against The Grain With Multiple Radio Buttons In Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Tips To Help You Excel

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips