microsoft+excel+training - linked workbook formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

resolvedResolved · Low Priority · Version Standard

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

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


Server loaded in 0.08 secs.