Linking & Refreshing Multiple Worksheets In Excel With G

[dogform]

Hi,

Could somebody confirm if it is practically possible with Gruss to have a number of open markets, each one individually linked to its own excel worksheet with all worksheets contained in one workbook? In addition, each market should be constantly refreshed as set by the excel sheet refresh values?

I have opened multiple pages in Gruss and set each page manually to a different worksheet in the same workbook and they all seem to be refreshing OK. However, is there a physical limit as to how many pages I can open in Gruss with each page market linked to a separate worksheet? Currently I have tested it out with 3 pages in Gruss to 3 sheets in excel but I would like to get the number much higher.

Also, is this approach the best for functionality and performance? I noticed the "Log Multiple Sheets Quicklink" option in the Gruss excel menu but it seems to provide dedicated market switching to a specific sheet whereas I wish them all to be under constant refresh.

Thx for any help and advice.

Rgds
Dog

[dgs2001]

dog, its completely possible to link many tabs to many pages.

Your VBA skills and pc processing power may get stretched though.!!

One thing I would be wary of is saving sheets using "Save As" from VBA, this causes excel to make temporary copies of things in ram which have caused me problems in the past.


Duncan

[dogform]

Duncan,

Thx for the reply.

I am using a 2.2GHz Core2Duo processor with 3gb of RAM with XP (SP3) as operating system. Would you know if that spec would run into difficulties with one excel workbook open with approx 25 sheets each linked to a separate page in Gruss ?

Agree about the VBA bit, it is all new to me and I realise how much it is needed to get things steaming along nicely.


Rgds
Dog

[alrodopial]

Duncan,

Thx for the reply.

I am using a 2.2GHz Core2Duo processor with 3gb of RAM with XP (SP3) as operating system. Would you know if that spec would run into difficulties with one excel workbook open with approx 25 sheets each linked to a separate page in Gruss ?

Agree about the VBA bit, it is all new to me and I realise how much it is needed to get things steaming along nicely.


Rgds
Dog

Why don't you try it?

All depends on the refresh rate of each sheet/page and if you further run VBA code in each sheet (i assume you do, so how much complicated it is?)
No one can tell you if it's ok. Only if you try it.

[dgs2001]

Why don't you try it?

All depends on the refresh rate of each sheet/page and if you further run VBA code in each sheet (i assume you do, so how much complicated it is?)

No one can tell you if it's ok. Only if you try it.

Wise words, the best method is indeed to try it.

If it works great, if it does'nt then I'm sure it probably can be made too.

Duncan

[Yorkie]

The pc that I have gruss running on is a P4 2.66Ghz with 1GB of RAM running XP. This has 2 direct connect hubs running on it along side BA. It is used purely as a server for these 3 things.

Currently I have BA using the quicklink feature and I have 69 BA pages linked to 69 excel sheets spread over 2 workbooks. Each sheet has it's own vba to run both the refresh rates and other commands including odds recording.

Everything works perfectly. Hope that gives you an idea of what you can do.