MS Online Programs- Excel in particular

[eknirb]

Question: I use the Excel Online a lot. I have tabs for each week of the year that I use for scheduling. Now is the week of 5/12-5/18. So I bookmark the Excel Online spreadsheet, and when I click on the bookmark, the first week tab it brings up is like December 1-8 or something. How do I have it point to the current tab?

Also:

I wanted to download the Excel Online spreadsheet to desktop Excel, which U can do, and a little LOG INTO WINDOWS LIVE dialog box pops up, and I log in with my Outlook.com email and password- and it will not accept it.

Any ideas? Posted this to the appropriate MS forums, no response as yet. Plus U guys know everything.

Thank U!

 

[andrew129260]

Try logging into windows live by going to their login page and see if it lets you in.

As for the first point can you use screenshots to show me what you mean?

 

[eknirb]

the first point has resolved itself, i fixed it somehow.

where is the URL for windows live?

 

[andrew129260]

Sign in to your Microsoft account

 

[eknirb]

I can sign into that just fine. But this dopey dialogue box will not accept the very same password.

 

[andrew129260]

are you putting your full email address and then password in there?

 

[eknirb]

you betcha

 

[Kari]

I can sign into that just fine. But this dopey dialogue box will not accept the very same password.

Notice that the email address used here must be the same used for storing the Excel Online document in OneDrive. For instance I have four different Microsoft email addresses added to Excel desktop application (and other Office products), to be able to open documents from Office Online applications from four different OneDrive accounts. Excel Desktop App can only open documents from Excel Online if the accounts are connected.

You can see which email accounts are connected to Excel desktop application (and other Office apps) from the upper right corner when you launch the app. You can also add or change accounts here. Screenshot from Office 2013:

​

When working with a workbook, click your name in the upper right corner to see connected accounts. Here the yellow highlight = my primary Office 365 account, green = first Microsoft account and so on:

 

[eknirb]

I have Office and it's activated, but I find:

Office isn’t associated with this account.
If you’ve already activated Office, sign out and then sign in with the Microsoft account you used to activate Office.
If you have Office but haven’t activated it, you can use your product key to activate. Activate Office now
If you don’t have Office, you can buy it in the Office store.

 

[Kari]

See the last (second) screenshot in my previous post. If your Excel (Office) is not connected to a Microsoft Account, instead of your name you should see the link Sign in there. Click the link and sign in.

 

[eknirb]

is that screenshot from regular excel or excel online?

 

[Kari]

is that screenshot from regular excel or excel online?

Excel Desktop App. You cannot edit / open Excel Online documents in Excel Desktop App without connecting it to a Microsoft Account.

A workaround is to download the file from OneDrive to your PC, then open it locally with Excel.

 

[eknirb]

OK, how do I connect desktop excel to my MS account? I see no name on desktop excel:

 

[Kari]

OK, you have an old version of Office as the screenshot shows. Forget the whole thing. In your case, only options are to download Excel workbook from OneDrive where it's stored to your local computer, then open it locally, or to use OneDrive Desktop App to sync files between your local computer and OneDrive.

For the future, download and install the OneDrive Desktop App and keep it synced: https://onedrive.live.com/about/en-gb/download/. When synced, the OneDrive copy of the file and the local file are the same, you can edit the local file, store it to OnDrive folder and sync.

BTW, this is a good example of how important it is to give enough information when asking assistance. Only in your 7th post in this thread did we find out you are using an outdated version of Excel, and that only because I noticed it from your screenshot.

 

[eknirb]

Had I been asked which version, I would've mentioned it. Thanks for the assistance.

 

[Kari]

It does not work like that, as you certainly know, that the OP gives as little information as possible and only reveals more if asked.

Anyway, about your other issue:

So I bookmark the Excel Online spreadsheet, and when I click on the bookmark, the first week tab it brings up is like December 1-8 or something. How do I have it point to the current tab?

Excel Online link always points to first sheet (list of sheets, bottom left). If organized as in this screenshot, Sheet2 as the left most (first), Excel Online opens in this sheet:

​

You can manually drag and drop and name the sheets as you wish. Put the one you want to be shown when the workbook is opened to the left.