An excel file on the web as an reference
 

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


--
ZorroZ
------------------------------------------------------------------------
ZorroZ's Profile: http://www.excelforum.com/member.php...o&userid=22825
View this thread: http://www.excelforum.com/showthread...hreadid=546169

An excel file on the web as an reference
 

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.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=546169