An excel file on the web as an reference

[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

[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.