Return to site

Add Dropbox As A Place In Microsoft Office

broken image


  1. Add Dropbox As A Place In Microsoft Office Free
  2. Add Dropbox As A Place In Microsoft Office Word
  3. Add Dropbox As A Place In Microsoft Office 2016

We've come a long way over the years when it comes to where we store our files. In the 80's and 90's it was all about local storage; the venerable C:, or 'C-drive'. Then in the 2000's, when connecting all of the office computers together on a network became the norm, companies told us not to save our precious data on the C-drive but instead to the network. The rational for this was sound; the I.T. department will backup the files on the network, whereas your local files are not backed up, and files on the network are accessible to you and others from any computer in the company.

Dropbox is tailored to the needs of large content creators. With Dropbox, you can sync file uploads as big as 2 TB—even massive CAD files and 4K video. OneDrive, on the other hand, is limited to 250 GB. And when it comes to marketing, advertising, design, and film and video workflows, Dropbox is a one-stop shop.

Now the push is to save data to 'The Cloud'. By saving data to The Cloud the files are of course backed up but they are also accessible to anyone inside or outside the company, provided they are granted the appropriate rights to do so.

Psssst; don't tell anyone because it will ruin the illusion, but 'The Cloud' is just a fancy way of saying 'someone else's hard drive'.

Here's how to disable Dropbox badge in Microsoft Office once and for all. If you don't know what I am talking about, open an Office document that is stored in a Dropbox folder. You'll see the badge on the right. Disable Dropbox Badge. Here's how to disable it. Click on the badge and you will see the 'Meet The Dropbox badge' window. A 'Place' in Microsoft Office is a location you can access directly from your Office apps, without using Windows File Explorer. Add Dropbox as a Place to open, share, and save files using Dropbox from within Microsoft Word, Excel, and PowerPoint.

Now that we are becoming reconditioned to saving our data to this nebulous Cloud, how can you save or retrieve your data from within Office 2016.

Because Microsoft has their own cloud-based storage solution called 'OneDrive', support for OneDrive is integrated into all of the Office 2016 products. But what if you store your information in Dropbox? Is there a way to add your Dropbox account to Office 2016? The bad news is, there is no built-in means of adding your Dropbox account to Office 2016, but there is a bit of a hack that you can perform on the Registry that will get the job done.

The below batch file script will detect the version of Windows you are running and modify the Registry to add Dropbox accessibility to Office 2016. Simply copy the code below into notepad and save the file with a .BAT extension (this stands for 'batch file' in case you're not to familiar with file extensions) and then execute the batch file.

NOTE: If your user account does not have administrator-level privileges, you will need to run this as Administrator. This can be done by holding down the SHIFT key and then right-clicking on the batch file and selecting 'Run as Administrator'. Enter in your administrator account name and password to run the batch file.

After you have update your Registry, perform the following steps to add your Dropbox account to Office 2016.

STEP 1

Launch Word, Excel, or PowerPoint 2016

STEP 2

Click FILE in the upper-left corner of the application to enter the Backstage

STEP 3

In the Backstage, select ACCOUNT on the left side (1)

How to add dropbox to office 365

Click ADD SERVICE(2)

Click STORAGE(3)

Click DROPBOX(4)

STEP 4

Your Dropbox account should now be listed as a connected service

STEP 5

Close and restart the application. Although this is not actually necessary, it's easier to do this than to write what you actually have to do. (It's 30 minutes before I leave for Christmas vacation and I'm feeling a bit lazy. I'm sure you'll understand.)

RESULT

Your Dropbox account will now be listed in the OPEN and SAVE AS panels of the Backstage view.

CODE BEGINS HERE

@ECHO OFF
ECHO This file modifies the registry in Windows 7, 8, or 10 to add Dropbox as a service within Office 2013/2016.
ECHO This script is provided as is and no warranty or support of any form is offered.
ECHO
ECHO Do you want to continue? Press CTRL-C to terminate this process.

pause

ECHO Please enter the complete path your dropbox folder in the following format, note there is no end slash: C:UsersUsernameLocation
SET /P dropboxdir=[promptString]

Add Dropbox As A Place In Microsoft Office Free

REM Check Windows Version
ver | findstr /i '5.0.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_2000
ver | findstr /i '5.1.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_XP
ver | findstr /i '5.2.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_2003
ver | findstr /i '6.0.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_Vista
ver | findstr /i '6.1.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_Win7
ver | findstr /i '6.2.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_Win8
ver | findstr /i '10.0.' > nul
IF %ERRORLEVEL% EQU 0 goto ver_Win10
goto warn_and_exit

:ver_Win10
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'DisplayName' /t REG_SZ /d 'Dropbox'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Description' /t REG_SZ /d 'Dropbox is a free service that lets you bring all your photos, docs, and videos anywhere.'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LearnMoreURL' /t REG_SZ /d 'https://www.dropbox.com/'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'ManageURL' /t REG_SZ /d 'https://www.dropbox.com/account'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LocalFolderRoot' /t REG_SZ /d '%dropboxdir%'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url40x40' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_40x40.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url32x32' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_32x32.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url24x24' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url20x20' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url16x16' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_16x16.png'
goto end

:ver_Win8
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'DisplayName' /t REG_SZ /d 'Dropbox'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Description' /t REG_SZ /d 'Dropbox is a free service that lets you bring all your photos, docs, and videos anywhere.'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LearnMoreURL' /t REG_SZ /d 'https://www.dropbox.com/'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'ManageURL' /t REG_SZ /d 'https://www.dropbox.com/account'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LocalFolderRoot' /t REG_SZ /d '%dropboxdir%'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url40x40' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_40x40.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url32x32' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_32x32.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url24x24' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url20x20' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url16x16' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_16x16.png'
goto end

:ver_Win7
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'DisplayName' /t REG_SZ /d 'Dropbox'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Description' /t REG_SZ /d 'Dropbox is a free service that lets you bring all your photos, docs, and videos anywhere.'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LearnMoreURL' /t REG_SZ /d 'https://www.dropbox.com/'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'ManageURL' /t REG_SZ /d 'https://www.dropbox.com/account'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715ad' /v 'LocalFolderRoot' /t REG_SZ /d '%dropboxdir%'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url48x48' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_48x48.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url40x40' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_40x40.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url32x32' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_32x32.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url24x24' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url20x20' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_24x24.png'
reg add 'HKCUSoftwareMicrosoftOfficeCommonCloud Storage2c0ed794-6d21-4c07-9fdb-f076662715adThumbnails' /v 'Url16x16' /t REG_SZ /d 'http://dl.dropbox.com/u/46565/metro/Dropbox_16x16.png'

goto end

:ver_Vista
:Run Windows Vista specific commands here
REM echo This script does not support Windows Vista
goto end

Add Dropbox As A Place In Microsoft Office Word

:ver_2003
:Run Windows Server 2003 specific commands here
REM echo This script does not support Windows Server 2003
goto end

:ver_XP
:Run Windows XP specific commands here
REM echo This script does not support Windows XP
goto end

:ver_2000
:Run Windows 2000 specific commands here
REM echo This script does not support Windows 2000
goto end

:warn_and_exit
echo Machine OS cannot be determined.

:end
ECHO The script is finished!
ECHO If you don't see any errors, you can close this window.
ECHO Any error messages can be posted on https://forums.dropbox.com/topic.php?id=93098
pause

Add Dropbox As A Place In Microsoft Office 2016

CODE ENDS HERE





broken image