Excel Query Workbook

[LindaEPI]

I have created a workbook with automatic refresh each time its opened. I did this through MS Query and it works prefectly. However, I need to email it to others and when I do, it doesn't work. Should it be saved in a different format?

So close...but not there yet.

Linda

 

[SkipVought]

Hi,

I suppose that they do not have access to your data source, yes?

Uncheck the auto update in Data Range Parameters, before sending the workbook. Use your macro recorder to record turning it on and off, if you like.

Skip,
[sub]
Just got a nuance...
to replace the old subtlety![/sub]

 

[LindaEPI]

I am using Excel 2000 and it does not give me that option.

 

[SkipVought]

Sure it does. It's been that way since Excel '97.

Select in the querytable.

Data > Import External Data > Data Range Properties

Skip,
[sub]
Just got a nuance...
to replace the old subtlety![/sub]

 

[LindaEPI]

Without using MS Query, is there another way to copy an entire row to a new worksheet using a macro?

I'm looking for a formula that would be
'If this cell is >0 then copy to new sheet with the entire row's information. leaving out the rows where the value is <0.

Sorry to be so persistent. I just want something simple to send to customers to place orders.

Thanks again for any help,

Linda

 

[SkipVought]

Again, I'd UNCHECK Refresh data on file open in the QueryTable's Data Range Parameters because that is exactly where this is controlled.

Instead, either refresh the table manually when you open, Data > Refresh or add this simple VBA to the Workbook_Open event...

Private Sub Workbook_Open()
    Sheet1.QueryTables(1).Refresh False
End Sub

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]