Sign In from Office Applications with your Office 365 Accounts!

This is one of the features that are not so well known by some of the people that I interact with and they are saying its not the same. A little background, I am really used to having AD + SharePoint + Exchange + Lync. I used to just edit a document in SharePoint or connect my Office say Excel to that document list and I have versioning and sharing of the document.

Come Office 365’s SharePoint online, we created a team sites for internal use. We decided not to use ADFS to sync office 365 identities and we have an existing AD in the local network. For some reason also we did not expose our AD to some personal machines and to VPN like the one that I am using here at home – this signs in to my Microsoft (Live) account.

image

Today I am reviewing reports and commenting on some worksheets. I Opened my Team Site and opened the list that I need to edit. Opened one Excel.

You know Excel Web App is not the same for me. An example, I cant find the Count at the bottom right of the worksheet when you highlight Cells.

image

Or some shortcuts like F5 (This refreshes the page, duh).

So what am I going to do? Open this on Excel of course, you go to Edit Workbook: Edit in Excel – like this:

image

This Pop-up and all of the errors will be there if you havent put your sharepoint URL on the trusted sites of IE.

image

Click yes and a couple more of Errors will come up – also there would be some excel errors.

image

So! What am I doing wrong? Again, I am used to that seamless integration of Office and SharePoint. Well maybe its because my Machine and SharePoint uses AD. Its because the identities are shared to all applications and services that we created a single sign-on environment. Oh well, I will just download the excel file, edit it and upload it again as Version 2. Not the ideal case, but hey I am working at home.

There is got to be a better way.

Go to your excel and click your account. See that Switch account link? Click it.

image

Type in your Office 365 Email Address, then click Next. It will look for the account and then type your password when asked. Click Sign-In.

image

After you sign in you will see your account, click it and change your account settings. I do this so that you know what account account I am using in Office at this moment. I got also live accounts that use SkyDrive so I don’t want to be confused.
image

You will see your account settings here, will also see the connected services. Mine has SharePoint.

image

Note that Office Caches your account, may want to protect your PC more now 🙂 Go out of that page by clicking the back arrow.

We can go back to the SharePoint site. Open the same Excel file. Then edit with Excel again. This has worked for me but I want to show you how to open it using the Open Menu of Excel.

image

Then open the Excel file. As you may notice, this is the same SharePoint document list that we are using.

image

You should be able to open the excel file now.

PS. Don’t forget to switch account!

image

PS.PS. You can add service the default live account, for some it may be confusing and insecure. I want to explicitly change accounts when needed over convenience of consolidating your accounts.

But if you really want to, change back to the main account and go to the account settings.

image

Select Office 365 SharePoint. That will ask again for your username and password of the Office 365 account then will return. When you go back to the Excel Workbook, You will see the two storage accounts linked with the other services.

image

There you have it! Back to work and happy Office 365 integration!

Advertisements

Fun Filler Text for Word (even in 2013) :P AKA Another Easter Egg

Quick Blog! So here I am, le me winding down the day and doing some documents and found some interesting thing to do with Word 🙂

So try these things out on MS Word, type the following and then press enter:

=Rand()

image

=Rand.Old()

image

and my favorite:

=Lorem()

image

 

Lol, so I dug around the internet and found out that these are actually a features of office called  “Filler Text” that you can use as place holder or dummy text for your documents.

With digging, I found out you can pass integer "parameters” in to those functions above.

So like =Lorem(N) with N as a number, example is =Lorem(10) which gives you 10 sentences or lines of text.

Yeaa, go on try out =Rand(100) 🙂

image

Windows 8 and Office 2013 Deployment Session

Hi everyone! Thank you for attending our deployment session. Hope you had fun and it was very informative for you to start considering these kinds of deployment.

These guys are checking out our demo rig with AMD Phenom II and an overclocked Saphire 7900 🙂 next time we will be using new servers so stay tuned!

Our Office 2013 customization tool! (Sorry no shot, was busy giving demo lol)

Here’s the completed installation of a customized Office 2013.

Here’s a snip of our MDT session. Will post links below!

Session is full! Thanks guys, even tho the competitor is at nextdoor Shangri-la 🙂 But, they cant virtualize like we did! hahaha!

Hyper-V running on my Windows 8 desktop!

 

Congrats to those who won PHIWUG shirts and thank you to Microsoft Philippines for the Venue as well as the featured give-away that night – a very sought after Microsoft Mouse 😛

Dining is also full!

Photos are in our Facebook Page: https://www.facebook.com/media/set/?set=oa.10151287043211179&type=1 

Also please dont forget to join us: https://www.facebook.com/groups/7327346178/

 

Again thanks for attending and heres the links of the softwares that we used:

MDT 2012 Update 1 : http://www.microsoft.com/en-us/download/details.aspx?id=25175

ADK: http://www.microsoft.com/en-us/download/details.aspx?id=30652

WDS on WS2012: http://technet.microsoft.com/en-us/library/hh974416.aspx

Office 2013 ProPlus Evaluation: http://technet.microsoft.com/en-us/evalcenter/jj192782.aspx

Office 2013 Customization tool: http://technet.microsoft.com/en-us/library/cc179097.aspx

files necessary to run the Office Customization Tool were not found. Run Setup from the installation point of a qualifying product

image

I have deployed office before, but is there something that I am missing? Is it because of the smell of the pizzas being cooked downstairs?

This KB (951339) : http://support.microsoft.com/kb/951339 is not very useful. I got to make this work! And now.

So I remember this thing by PHIWUG MVP’s post on our facebook page:

Lets go back to the TechNet article, Office Customization Tool (OCT) in Office 2013.

The OCT is available only with volume licensed versions of Windows Installer-based Office 2013, Office 2010, and the 2007 Office system. To determine whether an Office 2013 installation is a volume licensed version, check the Office 2013 installation disk to see whether it contains a folder named Admin. If the Admin folder exists, the disk is a volume license edition. If the Admin folder does not exist, the disk is a retail edition.

 

Somebody is sleepy and downloaded the wrong ISO.

 

So I searched the internet and found this": http://www.microsoft.com/en-us/download/details.aspx?id=30341

image

The OCT files are located in the Admin folder under the x86 (32-bit) and x64 (64-bit) folders, respectively. Download the appropriate file depending on whether you have 32-bit or 64-bit Office installed. Copy the entire \Admin folder into the folder that contains the installation image you are customizing.

 

Download the installer, then run.

image

Choose a destination directory (like unzipping) and then copy the admin folder to the office install folder.

image

Run Setup.exe /admin again and… tadahhhh..

image

Now, back to my deployment lab! Cheers!