Search results for query: *

The formulas with links seem to calculate considerably faster if I were to say, drag a row of formulas down and repeat them 100 times. There is a bit of lag (less than a minute) but I thought Excel might optimize moving the data from another workbook if it "knows" it has 100 links to resolve in...

Thanks for your quick reply. Unfortunately the data is not setup in tables. I wish it was, but I did not design the linked sheets. I will definitely keep your suggested method in mind for future projects though, because I didn't know you could do it that way. I can run a loop to open the...

So I am working on a bit of a stop-gap solution until a new set of workbooks/database are created. User locates the workbook they need to link to and is prompted with a list of sheets in the workbook. The file path and sheet name are stored in two cells of my current workbook. A button triggers...

Wow thanks for taking the time to explain it with such a lengthy reply. I had kind of given up on this and resorted to keying in everything manually but this will save me a ton of time if I can get it all together! :) I'll let you know how it goes, thanks again!

By the way, the application in question is STS SmartLook if anyone has ever heard of it. I google'd just about every possible thing I could think of to find documentation for it -- no luck! I imagine there should be some way to manually pass SQL query via command line which would probably make...

I have some 3rd party database software that I am working with. I am using VBA from Excel to open the software. To my knowledge there is no way to pass SQL script to the application via the command line and the documentation is extremely limited. There are several things I would need to do from...