onedrive

hi all. i'm trying to work with live data updates on onedrive.. but can't seem to get things to work seamlessly, so i'm toying with the following; Sub TESTOPEN() Application.ScreenUpdating = False Dim wb As Workbook, sh As Worksheet Set wb = Workbooks.Open("MYFILE") wb.RefreshAll wb.Save...

T o create files in the folder where the workbook is located Thisworkbook.Path is the preferred choice, but that gives errors with Office/365 and onedrive. In my case Thisworkbook.Path= "https://d.docs.live.net/beccd3471f9cbf60/Documenten/code snippets/Symbol table" local (in my laptop) this...

I have a fairly large Workbook with some 250+ worksheets. A lot of the data is entered on one sheet, which links through to several others and so on. The workbook is stored/saved to my OneDrive account but I’m finding that data entry is taking quite a long time. For example when I enter the data...

I have created a complicated spreadsheet using excel 2007. I shared it at onedrive so some friends can download it and use it also. When they open it they are got the message that file is corrupted (they are using excel 2010-2013-2016) and some formulas and conditional format was gone at some...

I have a series of spreadsheets saved in the cloud on OneDrive. These sheets contain links to each other through data lookups. I now need to save these sheets to my desktop but when I try this the data links don't naturally convert, they remain links to the OneDrive folders and therefore don't...

I have an excel macro enabled workbook that has 4 macro buttons in it for saving and emailing various groups of people. We have been using it for quite a while and have had no issues. Initially it was set to save to the users local directory. As a company we are moving to onedrive so I have...

Hi, some time ago I migrated most of my documents to OneDrive because of cloud and backup and stuff, but I just can't get the right configuration. I use win 10 + Office 2016 x64 + One Drive personal, but hey this OneDrive sometimes drives me nuts. Man why can't they make it simple and working...

I am going to placing an Excel file and Access DB in OneDrive. Can I have linked files between the two applications or do I have to run macros to import Excel into Access. Thank you for your help.

Hi, I am facing issue in updating text in a cell containing formula. Formula used is =IF(B2<>"","Enter user E-Mail ID here","") As intended, when B2 is not blank the Cell C2 will display text "Enter user E-Mail ID here". If I paste Email ID from outside workbook in C2, the email ID gets...

I have an Excel spreadsheet which I feed from a REST API. I'd like to re-use the same spreadsheet and share it via our OneDrive. Is it possible to use the URL to pass parameters into my Excel and change the data source? Like...

I'm working in PowerPivot and my linked source files come from a sync folder referencing my C drive. I'd like to source them from a shared location so my PowerPivot file will look to the shared location for new data when other users refresh the file. I can't find how to access the OneDrive...

Hi- I am trying to auto update data inputs from OneDrive excel online to my desktop. Essentially- I operate a model on my desktop that has historically used manually inputed data on a per project basis. I am now in need of a way to pull the data from an online source automatically as the...

This is annoying, I have a local copy of a spreadsheet which has a VBA script to import data from an xlsm on a OneDrive directory. Even though OneDrive is already running and logged in, the Workbooks.Open line will result in a Microsoft sign-in dialog popping up (Type the email of the account...

I'm looking for a solution to save a workbook to two locations. Location 1 is a folder on my local hard drive. Location 2 will be on either my OneDrive or one of the other cloud drives I use (not sure which, but probably the OneDrive). Would like the routine/macro to run from a custom button...

Hello, I have an excel workbook on my OneDrive folder that I want to share with some classmates -- I checked the box to "allow changes by more than one user at the same time - this also allows workbook merging". I did a test run and tried opening the excel workbook from two different...

Hello dear MrExcel! I need some Sub or ThisWorkbook code to upload this workbook to Microsoft OneDrive. Problem might be, OneDrive account is different then one of Office account. If it's possible, dear vba Ai, upload wbook after workbook is opened(not close or exit). Any help would be...

I embedded an Excel file into a WordPress page via OneDrive, but I can’t edit the cells on smaller screen devices. A PC with a mouse or touchscreen works fine. A Samsung Galaxy Tab 2 7.0 also works, though it requires multiple taps / double-taps to select the cell (shows white circle anchors...

Hello fellow Excelers out there!!! I need to open 2 files on onedrive with opening the main file in onedrive??? Or, If someone knows how to get 2 files to update Links upon opening main file??? THANKS 4 ANY HELP!!! :):):)

Hello all, I'm trying to figure out how to do this properly, but I can't figure it out yet. I am trying to make a cell in my workbook, reference the value of an uploaded file (and cell) in onedrive. Can anybody help me with this? I have no issues with a local computer address, but I can't...

Error received - "That workbook cannot be merged because it contains changes that have not been merged followed by later changes that have already been merged into the current workbook" Please help The rundown: I created a master workbook in Excel. I used "save as" to create a few copies of...