Willow Solutions, Inc. Leaf graphic
Willow SOlutions, Inc. Software that thinks like you do
News
Products
Case Studies
Tips
Willow Talk
Clients
Partners
Job Openings
Home

Willow Tips

 
 

Tip #2001-3: Create a scrolling news screen in Excel

 

Performance considerations for the scrolling newswire

The N2_UBMS instrument code that brings in the news headlines is updated quite frequently and it can quickly fill the rows in a worksheet with data. The Data Series itself is quite demanding on system performance. When we ran the Data Series to collect news headlines, we filled over 12,000 rows in a 24 hour period. An Excel 97 worksheet contains 65,536 rows.

Also, you can create only one Data Series per worksheet and you cannot have any real-time links on the same worksheet for the Data Series to work correctly.

 
Back to Tip

  What's New | Products | Case Studies | Willow Tips | Willow Talk | Clients | Partners | Job Openings | Home
  Terms of UsePrivacy Statement
Willow Solutions, Inc.85 Willow Street, New Haven CT 06511 USA203.777.5634info@willowsolutions.com