Import password protected Google Sheet into excel

[vba1234]

Dear All

Is there any way I can import the data from a Google sheet into excel, but is password protected and will update automatically the excel sheet I am working on by using the refresh button?

Also, the google sheet has a lot of columns that I do not need. If I can import the google sheet into excel, edit the excel and then have only the columns I need updated from the google sheet?
Thank you

Vba1234

[FDibbins]

Who owns the protected file? This sounds to me like you are trying to access files that you shouldn't be?

[vba1234]

Hi Ford

The files and data are from the company that I work for. I need to work on the data. Currently I login via Google, go the google sheet, put in password and then highlight the column data (use CTRL+C) and the CTRL+V into the excel. I have to do this for all the different columns that I need. I wanted to know if there was a way I could open my excel (file I am working on) to update automatically. I tried to make a link with the google sheet and excel sheet (checked on YouTube) and when I try to link to an excel sheet, I get the cell showing SIGN IN.

If you or anyone has any ideas, that could make my task easier, that would be great.

Thanks

Vba1234

[vba1234]

Dear All

Please does anyone have a solution to this?

Thank you.

Vba1234