Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I got my excel version from Office 365. I edit and save the excel files in one drive for my other team. I send the link of the online excel to my client via email. I noticed when the link is clicked, online excel opens but the cursor is not in row 1 column A. It is in row 15 column F. My other excel files also has the same problem. When online excel is open via link sentâ?¦the file opens up but not in row 1 column Aâ?¦ What should I do to make sure row 1 column A is the row and column that will be shown when excel online is opened?
Solved by V. U. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 26/09/2018 - 12:12
Welcome to Excel chat, I see that your question is about Saving file and Sending link and the cursor is not at the position you want.
User 26/09/2018 - 12:12
Yes
Excelchat Expert 26/09/2018 - 12:12
I can help you with that problem, I'll be able to provide you a solution and explanation
Excelchat Expert 26/09/2018 - 12:13
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
Excelchat Expert 26/09/2018 - 12:13
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User 26/09/2018 - 12:13
ok
Excelchat Expert 26/09/2018 - 12:13
Can you please share the excel file and link with me so that i can check where is the problem
User 26/09/2018 - 12:14
it is private
Excelchat Expert 26/09/2018 - 12:15
I understand, But i have to see what is the problem in workbook.
Excelchat Expert 26/09/2018 - 12:18
You can share a Dummy file and link for that Dummy file with me.
Excelchat Expert 26/09/2018 - 12:22
are you there?
User 26/09/2018 - 12:24
do you have any idea?
Excelchat Expert 26/09/2018 - 12:24
You need to save file with the exact location of Cursor where you want it to once opened.
Excelchat Expert 26/09/2018 - 12:24
Close the workbook
Excelchat Expert 26/09/2018 - 12:24
Check it by reopening at your drive only.
Excelchat Expert 26/09/2018 - 12:25
if it is at right place or not
Excelchat Expert 26/09/2018 - 12:25
than share the link once again.
Excelchat Expert 26/09/2018 - 12:26
Does this solution solve your problem?
Excelchat Expert 26/09/2018 - 12:27
Do you have any other questions about this problem and the solution?
User 26/09/2018 - 12:28
when I opened it in one drive...the cursor is in the place I want it to
User 26/09/2018 - 12:28
but the online excel... still the cursor is not in the right place
Excelchat Expert 26/09/2018 - 12:29
You need to save file at you drive means local drive first not on one drive.
Excelchat Expert 26/09/2018 - 12:29
Download and save the file at your Local Drive.
User 26/09/2018 - 12:30
then after saving in my local drive? drag it to one drive?
Excelchat Expert 26/09/2018 - 12:30
Then open the file from you Local drive and take the cursor at A1
Excelchat Expert 26/09/2018 - 12:31
as you want and save it.
Excelchat Expert 26/09/2018 - 12:31
then take it to one drive and share the Link.
Excelchat Expert 26/09/2018 - 12:31
To check you can share the link with me for a dummy file.
User 26/09/2018 - 12:33
yayyyy !!! It worked !!!!
Excelchat Expert 26/09/2018 - 12:33
Does this solution solve your problem?
User 26/09/2018 - 12:34
checking
Excelchat Expert 26/09/2018 - 12:34
Okay!
User 26/09/2018 - 12:37
yes. it solved my problem. It worked. thanks
Excelchat Expert 26/09/2018 - 12:37
Do you have any other questions about this problem and the solution?
User 26/09/2018 - 12:39
no more . thanks
Excelchat Expert 26/09/2018 - 12:39
Can i close this chat now?
User 26/09/2018 - 12:39
yes. thank you very much
Excelchat Expert 26/09/2018 - 12:39
Thanks for coming to Excel chat. Feel free to leave any comments or feedback. Have a nice day.
Excelchat Expert 26/09/2018 - 12:39
Keep using Excel Chat!

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc