Annulleret

Excel: Refresh Web query & lock pictures

Hello,

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 :)

Thanks,

M

ps: no generic bids please

Færdigheder: Databehandling

Se mere: spreadsheet on web, something cool to print, n query, me excel, generic excel, fix the web, excel to web, excel macro how to, cool web, work on excel, web ps, refresh, query table, qualitative , print is cool, print cool, pointing, pivot table excel, macro excel, macro + excel, LOCK, fix excel macro, excel table, excel PIVOT, excel pivot table

Om arbejdsgiveren:
( 38 bedømmelser ) Montreal, Canada

Projekt-ID: #197968

1 freelancer byder i gennemsnit $60 for dette job

skilledsir

hi,i can do it for u,plesase send me more details ,i am online [url removed, login to view] forward to your reply

$60 USD på 1 dag
(5 bedømmelser)
3.3