Very slow worksheet - any limitation of program size?

[HusseinNaserald]

Hello,

I have a worksheet of about 1.3MB, of which a big part is a program (several pages of code). I have mathcad 15 running on Win7. I tried my laptop with Win7 and the the same happens: when making changes in worksheet (adding a line, editting text or function), I am facing very slow responsiveness. Sometimes I need to wait more than a minute for a single change of adding a letter! Nothing appears on the screen and suddenly a log of a couple of instrutions is done in a sec.

I closed all open programs but that did not help.

Is there any limitation on the size of the coded program?

Any help will be appreciated.

Hhussein

[Werner_E]

I haven't run into that kind of problem so far, but looking at your sheet I see what you mean.

I think its not the size or length of the worksheet itself but the the size of your program. Your program out(data,...) stretches over 21 pages and is handled as sort of a unit when edited. So the delays are no surprise.

I am sure you can split that routine in a couple of much smaller, manageable ones which are then called from a "main" program. An additional benefit would be much better readability of the calculation sheet.

[VladimirN]

May also help here is linking multiple Mathcad documents.

[MikeArmstrong]

Werner Exinger wrote:

I think its not the size or length of the worksheet itself but the the size of your program. Your program out(data,...) stretches over 21 pages and is handled as sort of a unit when edited. So the delays are no surprise.

I am sure you can split that routine in a couple of much smaller, manageable ones which are then called from a "main" program. An additional benefit would be much better readability of the calculation sheet.

As Werner said breaking it down would help readability and also help with checking. I personally would not like someone to pass me that sheet and ask me to check it.

[ValeryOchkov]

Werner Exinger wrote:

Your program out(data,...) stretches over 21 pages and is handled as sort of a unit when edited.

One good rule - one function-program must be not bigger than one screen.

Or go to http://communities.ptc.com/groups/mathcad-paradoxes