Get data from web using query (Access to resource is forbidden)

Hey,

I want to import a table to excel from a website (can't post url yet, please see pic)

However, it was connecting easily to the website, now it shows "Access to resource is forbidden"? Please help me rectify this.

Untitled.png

It is a public site and does not require any authentication.

Thanks!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Seems to be working here. The query refreshes without an issue.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Name	Close	Signal	Links	Analysis
2	3M India Ltd.	21041.2	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Nicely Trending Up, Bullish Trend Reversal., Aroon Indicator indicates a strong Upward Move. Bulls in control , Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-100 MA Up, Price Up Nice Trend, SMA-200 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up Nice Trend, S...
3	Nifty Pharma	10472.2	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Nicely trending Price with Rising volume, Macd /Signal line bullish crossover. Seems to be trending nicely, Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up Nice Trend, SMA-10 MA Up, Price Up Nice Trend, SMA-15 MA Up, Price Up Nice Trend, EMA-50 MA Up...
4	Info Edge (India) Ltd.	3110.3	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up Nice Trend, SMA-10 MA Up, Price Up Nice Trend, SMA-15 MA Up, Price Up Nice Trend, EMA-50 MA Up, Price Up Nice Trend, EMA-100 MA Up, Price Up Nice Trend, EMA-200 MA...
5	Bajaj Auto Ltd.	2995	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Near One Year High and has strong uptrend., Nicely Trending Up, Positive Breakout., SMA-10 MA Up, Price Up Nice Trend, SMA-15 MA Up, Price Up Nice Trend, EMA-10 MA Up, Price Up Nice Trend, EMA-15 MA Up, Price Up Nice Trend, Strong price rise . caution keep a Tab on volume., R...
6	Hindustan Unilever Ltd.	2334.55	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Rising Price with Rising volume, Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up Nice Trend, SMA-10 MA Up, Price Up Nice Trend, SMA-15 MA Up, Price Up Nice Trend, EMA-50 MA Up, Price Up Nice Trend, EMA-20 MA Up,...
7	Aarti Drugs	1488.85	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Made new One Year High and trading with good Volume., Strong price rise supported with good volume., Nicely Trending Up, Aroon Indicator indicates a strong Upward Move. Bulls in control , Very Strong up trend., Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-100 MA U...
8	Dhanuka Agritech	813.65	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Near One Year High and has strong uptrend., Macd /Signal line bullish crossover. Seems to be trending nicelyToo frequent crossovers, Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-100 MA Up, Price Up Nice Trend, SMA-200 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up...
9	SBI Cards & Payment Services Ltd.	755.95	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Near One Year High and has strong uptrend., Nicely Trending Up, Aroon Indicator indicates a strong Upward Move. Bulls in control , Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up , Bullish CO, SMA-10 MA Up, Price U...
10	Cipla Ltd.	689.1	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Macd /Signal line bullish crossover. Seems to be trending nicely, Positive Breakout., SMA-50 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up Nice Trend, EMA-50 MA Up, Price Up Nice Trend, EMA-5 MA Up, Price Up Nice Trend, EMA-10 MA Up, Price Up , Bullish CO, Made new One Year...
11	Mahindra & Mahindra Ltd.	588.8	Strong Bullish	TechnicalsSMA/EMA ChartPatterns	Nicely Trending Up, Aroon Indicator indicates a strong Upward Move. Bulls in control , SMA-200 MA Up, Price Up Nice Trend, SMA-20 MA Up, Price Up Nice Trend, SMA-5 MA Up, Price Up , Bullish CO, SMA-10 MA Up, Price Up , Bullish CO, SMA-15 MA Up, Price Up Nice Trend, EMA-100 MA U...

Sheet: TopStockResearch

I don't know what your set-up is, but if I can access the query without an issue, then the problem is at your end, not with the website. Are you working on a work PC? Is there a limit to the number of times you can access the website?

Super - glad you are sorted.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.