microsoft+excel+training - Linked workbook

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

Resolved · Low Priority · Version Standard

Linked workbook - "formula too long"

Cameron has attended:
No courses

by - delegate Cameron [1 post] (2007 Sep 21 Fri, 14:15) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: linked workbook - "formula too long"

by - trainer Richard platinum contributer [818 posts] (2007 Sep 21 Fri, 14:44) Reply

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