I have a request from a client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways. I ahve a QV app with 18 bookmarks and then a copy/paste process of tables into Excel. This is not optimal and since the project and future developments of ad-hoc tables needs to continue after my departure, I had initally chosen to try and implement 18 objects using set analysis with bookmarks (thinking it would be easier to hand-over with minimal training) and a macro doing the export into one template spreadsheet.
however, this 40 Mb document hangs the PC almost systematically, as when I create the set analysis charts (by about the 10th), the Task Manager shows this 40 Mb file with QV opent taking up about 3 Gb of RAM and hanging indefinitely the PC. Initially I thought it might be the bookmark set analysis that might be more memory hungry, so I explicitly stated the set analysis and... same result.
Has anyone seen this kind of behaviour in QV Desktop (File is 40 Mb, PC has 4 Gb RAM)? Any explanation as to why it does this? Any workaround (apart from throwing more RAM at the machine)?
