OT: Spreadsheet software for very large files

< Next Topic | Back to topic list | Previous Topic >

Pages: < 1 2 3 4 >

Posted by dan7000
Oct 3, 2014 at 01:25 AM

Oops looks like Panorama is Mac-only :(

Posted by Dominik Holenstein
Oct 3, 2014 at 11:59 AM

Panorama Sheets and Panorama are available for Windows as well:
http://www.provue.com/panorama/riskfreetrial/index.html

Best,
Dominik

Posted by Alexander Deliyannis
Oct 3, 2014 at 05:58 PM

I find the product very interesting, but it appears to have not been upgraded since 2010:
http://www.provue.com/Downloads/history/index.html

Posted by dan7000
Oct 3, 2014 at 07:32 PM

Panorama crashed with the first spreadsheet I tried to import.

Sorry for veering even more off-topic but for those who are interested, a colleague discovered that the spreadsheets work much faster in Excel when hyperlinks are removed - a couple of the columns had hyperlinks. Perhaps excel verifies the links when opening or filtering the database or something. That would certainly slow things down.

Posted by 22111
Oct 4, 2014 at 03:14 PM

Just for the record: Zeoli mentioned Panorama Sheets (and did this in spite of dan7000’s specifications), and now dan7000 speaks of Panorama. It’s unfortunate dan7000 seems to be inclined to give up sometimes rather soon (“Mac only”), since I doubted from start on that his amount of data would go into Sheets (see his first post), which is incredibly crippled vàv Panorama, both in functionality AND in amount of data it can process (but also in price, to be fair) - of course, any such choking should not result in a crash but in an adequate error dialog; I myself had considered Sheets briefly once, and had immediately mused about the availability of and reason in a possibility to cut down existing data, far exceeding the 50 mb allowed by Sheets, into some “relevant” part(s) Sheets then could process; I discarded this idea in favor of some further scripting, instead of multiplying tools, and multiplying transitions forth and back.

This being said, it would have been interested to know some details here - OT or not, it’s IM, and that should always be welcomed here if I dare give my opinion?

As it is, it’s to be feared though that this thread will die soon as did so many threads before: without giving any new info whatsoever, onT or OT… (Well, the Excel slow down by links is a known fact, thus cannot count as new info: http://www.excelforum.com/excel-general/938169-excel-slow-open-save-i-think-because-of-hyperlinks.html , http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/12/18/top-10-list-of-performance-issues-in-excel-workbooks.aspx , and so on.)

And I had been really eager to get some new knowledge here, about Sheets and/or Panorama… ;-(

Pages: < 1 2 3 4 >

Back to topic list