Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 04:40:31 +0000



Invalid workbook or display reference error

View Count: 1611

[2014-07-28 22:24:09]
enemyspy - Posts: 306
when I opened chartbook today I was met with "Invalid workbook or display reference" on spreadsheet. After a long time the spreadsheet populated.

-Upon trying to manipulate the sheet error message read "workbook locked"

-Then spreadsheet disappeared and A giant red X came up on the white screen Micrsoft.NET framework error "Unhandled exception has occured in a component in your application"
exception type 'system out of memory'

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at ᣗ.ឦ..ctor(Int32 A_0, Int32 A_1)
at ᣗ.ᝈ.ᜀ(Int32 A_0, Int32 A_1)
at ᣗ.ᝋ.ᜁ(ᜃ& A_0, ᝈ A_1, ᝈ A_2)
at ᣗ.ᝋ.ᜀ(ᜃ& A_0, ᝈ A_1, ᝋ A_2, ᝋ A_3)
at ᣗ.ᡪ.ᝢ(ᜃ& A_0, ᝈ A_1)


Date Time Of Last Edit: 2014-07-28 22:24:38
[2014-07-28 22:43:50]
enemyspy - Posts: 306
anyway had a recent backups stored every where so only lost about 8 hours of work worth of additions that needed to be deleted anyway due to a lack of productivity. But still whats the deal with this error and how do we fix/avoid it?
[2014-07-28 23:02:43]
Sierra Chart Engineering - Posts: 104368
This is from the old .NET-based spreadsheets within Sierra Chart which are no longer under development. We are developing new Spreadsheets which are completely free of this evil Microsoft .NET, which we are in the process of releasing at this time. We expect the development to be done hopefully in about another month.

Possibly due to the amount of data on the spreadsheet you ran out of memory. We really do not know. Generally when something like this occurs we recommend the user restarts the computer.

In the new spreadsheets, this kind of problem will not occur, and if some kind out of memory condition does occur, it would be well managed and we will be able to directly help with it.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2014-07-28 23:04:46
[2014-07-28 23:48:56]
enemyspy - Posts: 306
yeah I agree microsoft is evil. They use the dark side for sure.
[2014-07-29 00:53:28]
Sierra Chart Engineering - Posts: 104368
We reviewed our progress on the new spreadsheets, and we expect and they are ready for general release in no later than a month from now.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account