Excel: refresh web queries and lock position of pictures


I have a spreadsheet that contains two worksheets. One sheet holds data, and the other contains a pivot table.

Data sheet:

The information in the data sheet is auto-populated using a web query pointing to an intranet url (so it may not work on your end).

Right now I have the data refreshing itself, but the user is prompted to "Enable data refresh". I would like to get rid of that and have the data refreshed through a macro.

The data is qualitative data; there's no numbers involved.

Pivot table:

I also have two pictures in the spreadsheet. I would like to "lock" the position so that users can't move them around, and that they don't move around when users resize columns.

And could you fix the print layout so that it's as legible as possible? Can this be done through a macro?

If you have any creative ideas on how to do this, or if you think of something cool to add, please let me know :)



ps: no generic bids please

Beceriler: Veri İşleme, Visual Basic

Daha fazlasını gör: excel vba refresh web query, lock pictures excel, excel lock refresh, lock excel query, excel web query lock, excel web query fix data position, excel refreshing done, excel 2007 lock position, excel web query picture, refresh options web queries vba excel, excel refresh web query, refresh query excel url work vba, excel vba refresh web, lock image excel spreadsheet, lock image excel, excel locking positions, excel lock picture, refresh web query excel vba, refresh sort excel, lock excel sheet data refreshed, web query lock columns, visual web, spreadsheet on web, something cool to print, me excel

İşveren Hakkında:
( 38 değerlendirme ) Montreal, Canada

Proje NO: #197987



Please PM me the part of the spreadsheet contain the drawings. I would like to see what it is and what print option will be best for it.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)

Bu iş için 9 freelancer ortalamada $68 teklif veriyor


VBA developer since 1997. Can do. Regards, Svet

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(56 Değerlendirme)

Hi there, I am an expert in Excel and VBA. I can do this task no problems at all. Please note that I am based in the UK so some timing differences may occur. Kind regards Nash

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

This sounds like the sort of thing we're good at, with our extensive Excel / VBA experience. Could you post a copy of the spreadsheet so that we can see what we'd be letting ourselves in for ? Some data from the URL wo Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

, I finished this type of project early. It is one day job. On peut communiquer en français si vous voulez.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

Hi Check pm for detail Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

have ideas how to do this job

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello; Let me have your file and go through. REgards

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi. I'm an Excel Jedi with 16 years of experience with many corporate clients including The Body Shop, Rolls-Royce Motor Cars and Estee Lauder. This doesn't sound too complicated. I'll turn this around for you in a day Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)