An excel file on the web as an reference

Z

ZorroZ

Hi!

I would like too have a pricelist in excel format on the web(webfile),
so that I can give some other people another file which gets the
information from my webfile. so when I change the value(prices) the
prices will change in there files as well when they choose too update.

How should I do that, and how would a formula look like?

Thanks in advance!


Best Regards


ZorroZ
 
C

CaptainQuattro

Keep your data table as simple as possible and save it to your website.

In the user workbook, on its own worksheet, create a web query by
using
Data > External > New web query

In step 2. choose the entire page.

Once the query has been created, right-click on any cell in the query
area and click data range properties for further options.
 
Top