Question description:
This user has given permission to use the problem statement for this
blog.
Query was working on my Gsgeet, then now pulls a whole sheets data in to one row rather than separate cells. Also I would like to share the file but then unshare for security reasons if you could tell me how.
Solved by E. E. in 42 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/06/2018 - 04:35
Hello
User
06/06/2018 - 04:35
Hi
Excelchat Expert
06/06/2018 - 04:35
Welcome to excelchat.
User
06/06/2018 - 04:35
Thanks
Excelchat Expert
06/06/2018 - 04:36
I need to see the query formula and the sheet please.
User
06/06/2018 - 04:37
If I share the link to gsheet, is there I was I can then take your permission away afterwards?
Excelchat Expert
06/06/2018 - 04:37
Yeah, of course.
Excelchat Expert
06/06/2018 - 04:37
Before we go ahead.
Excelchat Expert
06/06/2018 - 04:37
I need to know whether you are using web query or not?
User
06/06/2018 - 04:38
I don't know what that means :) I'm using a query in Googlesheets, to pull in data from other sheets in the same googllesheet doc
Excelchat Expert
06/06/2018 - 04:38
If it is a web query/ web scraping, then I can't help you with it since web scraping is out of our service scope.
Excelchat Expert
06/06/2018 - 04:38
Oh, okay, its alright then.
User
06/06/2018 - 04:39
Do I just paste the link?
Excelchat Expert
06/06/2018 - 04:39
Yeah, that would do. Please share the link.
User
06/06/2018 - 04:39
https://docs.google.com/spreadsheets/d/1UcU4zFGkqvhhKM509CEQDYJwQdK37eArGVKlo8NyyKk/edit#gid=1909847426
Excelchat Expert
06/06/2018 - 04:40
I'm on the sheet, where is the query again?
User
06/06/2018 - 04:40
The query is on the Do Not Edit tab, cell A:2. It was working, but not there is an error coming from the Barclays tab,
User
06/06/2018 - 04:42
so on Do Not Edit, cell A3 is pulling out all the information from the Barclays tab, rather than putting it on separate lines like the other tabs it pulls in
Excelchat Expert
06/06/2018 - 04:44
I see the problem now.
Excelchat Expert
06/06/2018 - 04:45
Please give me some time.
User
06/06/2018 - 04:45
Great
User
06/06/2018 - 04:49
It did work. Then stopped, so I made a new barclays tab, copied accross the info and it worked again. Then suddenly stoped!
Excelchat Expert
06/06/2018 - 04:50
Thanks for the info. Please stay with me, I'm looking into it.
User
06/06/2018 - 04:50
Great ta!
User
06/06/2018 - 04:51
On the Barclays tab, if you delete the date in I:13 it removes the error. But as soon as put the date back in it stops work
User
06/06/2018 - 04:51
ing
Excelchat Expert
06/06/2018 - 05:01
Thanks for waiting.
Excelchat Expert
06/06/2018 - 05:02
Unfortunately I wasn't able to find any reason why it shouldn't work.
User
06/06/2018 - 05:03
Ok...
Excelchat Expert
06/06/2018 - 05:05
However I have noticed that a datevalue in I5 make the formula works perfectly.
User
06/06/2018 - 05:05
what does that mean?
Excelchat Expert
06/06/2018 - 05:06
Please input a date in I5
User
06/06/2018 - 05:06
Yup that works...no idea why!?
Excelchat Expert
06/06/2018 - 05:08
I'm not sure why.
User
06/06/2018 - 05:08
I don't really want a date in I5 :) . Would one of your colleagues know?
Excelchat Expert
06/06/2018 - 05:09
Yeah, I think someone might be able to find the actual problem.
Excelchat Expert
06/06/2018 - 05:10
Once this session ends, you can post the problem again. Please mention that the date in I13 is causing the problem.
User
06/06/2018 - 05:10
Ok I need to leave the office now, will I have to pay another $9.99?
Excelchat Expert
06/06/2018 - 05:10
Would you want to know how to remove file sharing permission now?
User
06/06/2018 - 05:10
Yes please
Excelchat Expert
06/06/2018 - 05:11
Okay, Please follow the instructions.
Excelchat Expert
06/06/2018 - 05:12
I presume you already know how to share the file.
Excelchat Expert
06/06/2018 - 05:12
Please go there, At the bottom right of the "Share with others" window, click Advanced.
User
06/06/2018 - 05:12
Yup I click on the share
User
06/06/2018 - 05:12
Yup
Excelchat Expert
06/06/2018 - 05:13
Next to the person you want to stop sharing with, click Remove
User
06/06/2018 - 05:13
You are not in the list as I gave you the link rather than email invite
Excelchat Expert
06/06/2018 - 05:13
Or if you have set global permission, meaning permission for everybody,
Excelchat Expert
06/06/2018 - 05:14
Click on the change button.
Excelchat Expert
06/06/2018 - 05:15
The change button is on the right of "Anyone who has the link can view" text.
Excelchat Expert
06/06/2018 - 05:15
Have you found it yet?
User
06/06/2018 - 05:15
Ok I need to leave the office now, will I have to pay another $9.99?
User
06/06/2018 - 05:15
Yes
Excelchat Expert
06/06/2018 - 05:16
Yeah, if you want to post another session then you have to pay.
User
06/06/2018 - 05:16
Yeah sure
User
06/06/2018 - 05:16
Thanks
User
06/06/2018 - 05:16
Have a nice evening!
Excelchat Expert
06/06/2018 - 05:16
I'm sorry for the inconvenience. have a great day.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.