Excel Refresh Data : The Column Wasn't Found - Data Source FIx

 I have a spreadsheet which a data is linked to Google Sheet, after 3 month I try to update the data (refresh the data source) and got an error sayaing

"The Column (column name) Wasn't found".

After minutes of looking for the answer turn out it was an easy fix.

The problem is the google sheet permission itself.

What you need to make sure the sheet is set to " Shared with everyone". 

That's it!

The problem,

However sharing with everyone could be risky since everyone could change the original value. In my case, I published the sheet as csv first, then use the link to link with excel power query.

This way users can only see the csv version of the sheet and unable to change any values.

Comments

Post a Comment

Popular posts from this blog

How to Fix Common Astro Remote Problems

Image
Without astro remote, our decoder just like a non-functional decoder. Latest decoder such as beyond have no button at all (only power button..sigh) compare to old decoder which have some handy buttons. There are actually some trick you can do fix your remote: Volume and Mute Button Not Working. We get this a lot, whenever we press the Volume or the mute button it does not work. Actually it is simple to fix it, press the volume up (+) button together with the big OK button until LED indicator blink twice. Now your volume and mute button should work. In case it volume up did not work, try with the volume down (-) button. All button Not working Properly First of all this normally caused by weak battery. If you are lazy to buy one, remove the battery and smash it a little bit with hard stuff. Normally I just bite it with my teeth. the good advice would be buy a good battery and prepare additional battery. Reset your Remote Reset is handy trick to overcome any problem with our re...
Read more

4 Steps to Fix Dell Blinking Orange Light

Image
The blinking amber power button or also called Orange Light of Death is a common problem for Dell Desktop. The reason would be the electrical faulty on the Motherboard, front panel or Power supply. However most of the time the trick is to push the black button (of the Power Supply) twice. 4 steps with pictures: 1. Long press the blinking power button of  the front panel until the orange light goes away. 2. Locate the black button (of the power supply on the back panel) and long press until  you see a flashing orange light on the power button. You also could hear the sound of the CPU fan. 3. Release the button, and now long press it again (about 10 seconds). 4. Turn on your computer by pressing the power button and it should work.
Read more

How To Stop Celcom Mobile Internet Prepaid

If you are using a celcom prepaid, you can subscribe to daily, weekly or monthly broadband internet by dialing *118#. If you want to unsubscribe any internet subscription above, simply type STOP (capital letter) and send to 28882. type: STOP send to 28882 This method valid for any prepaid users. Before this, celcom will ask users either to continue or stop their internet subscription before the subscription period end. However now your subscription renewal is automatic and you need to stop the subscription manually otherwise it will continue to subscribe until your are out of credits. You do not have to worry because celcom will notify you about the automatic renewal with SMS. If you get an error after sending STOP to 28882, just try later and they will notify you with an SMS saying your are no longer subscribed to the any internet plan.
Read more