As I have many tables in one tab, when open the tab everytime. it takes long long time to load all the tables at a time and always get "out of vitural memory".
As the no of tables and data cannot be reduced. I'm thinking if I can make all table detached as default and have a macro to attach and calculate the table one by one.
Anyone can help?
Thanks in advance.
You may want to have all tables minimized and just maximize ones you need on open. The minimized tables will not take up that much of memory.
Otherwise, something basic seems to be wrong with your QVW, either design or liked table. Or you may be working with huge data set. It should not take that long to show the object in one tab.