onedrive

I have a complicated Excel workbook that I want to build a public website frontend for, so users can enter their inputs and have the Excel-generated results/charts display in response. Embedding the entire workbook via iframe from OneDrive-Personal or -Business/Sharepoint nearly works but it...

My question is: I use VLOOKUP all the time in Excel and am very good at it. I am being forced to start using Excel on-line with OneDrive and, major issues. I can’t figure out how to reference the Table_Array. I have two spreadsheets, Book1 [where the formula will go] and Book2 [where the...

We recently migrated our files to OneDrive. Our previous use of Path would render a windows address string. It now renders the url of the cloud file location. When using the link, the path opens the url in an explorer window requiring another authentication. We currently have the cloud...

I'm using Office365 on several machines that all run Windows 10 Pro. I login to those machines using a Microsoft Account and I have all the syncing options that I can find set to sync. My OneNote stuff syncs as do my spreadsheets. Changes on one machine show up on another machine even in the...

Hello, A project I'm working on has a button that is supposed to create a static, macro free copy of the workbook and save it to the folder which is located on OneDrive. This button will be used by multiple users, not just me. I have this coded and it works perfectly whenever I test it, but...

Hi everyone, new to the boards and stuck on resolving an error. Using O365 Excel. I first did anything with VBA five days ago, but I'm competent otherwise. What I'm trying to do, and what happens when I do it This is a fairly simple code that runs as a part of a larger process. The code...

So i have the xlsm file that is beefy with VBA. Some of these VBA codes take a considerable amount of time to finish performing their task to the 10,000+ lines of data i have. I've noticed this very non consequential bug that happens. I just want to note that i DON'T HAVE ANY ONEDRIVE CODES. I...

I have a workbook that works perfectly when saved locally. Even with hidden data and "Protect Sheet" enabled, all is well. HOWEVER, when I save my workbook to OneDrive, and view the workbook online, all my functions return a #Value error. My worksheets have Review/Protect Sheet enabled...

My company has a xls file on a onedrive folder. How can I link a worksheet to one of the worksheets in that workbook so it always is up to date? -Eds

I'm sure you've seen this subject before but I am pulling out my hair. Excel is getting worse and worse at hanging while I'm using it. I'm using Office 365 with a Windows 10 PC, stand-alone. I'm also using OneDrive and just a hunch that it is playing a part in what's going on. BUT it will also...

I use OneDrive, configured to combine my System's Documents folder and OneDrive's Document folder. I didn't realized it was set up this way, I guess it's the default setting, until I failed to find my System's Document folder on my C: drive and couldn't. The problem is that OneDrive seems to...

We just changed from Dropbox to OneDrive. I have many macros and files that reference c:\dropbox\directoryname and I need to change them ALL to read c:\onedrive\directoryname instead. Can someone help me write a macro that would open each XLSM file in c:\files, then change the word "dropbox" to...

Morning All, I'm currently just starting out using onedrive and am having trouble getting some of my documents on my computer syncing with the onedrive counterparts given that it seems to be taking a very long time is there any way of creating a message box to show the status of the sync and...

Dear All, Just wondering about the new function in Excel for Co-Authoring, is it possible to Co-Authoring a file in the local share drive rather than cloud like onedrive? Or we need to use the old way to do the share workbook? Cheers, Peter

Hello to all. I've been studying Excel for about a week so please keep that in mind! :eeek: I understand the "Refresh" button is for updating the Pivot Table Cache when the Source Data has changed. Someone told me that is will also update the changes made by others on a Co-Authored...

I desperately hope someone can help.I have some simple VBA code that makes a copy of a worksheet and saves it to a shared folder on Business OneDrive, the main bit of code is just: Sheets("Data").Select Sheets("Data").Copy ActiveWorkbook.SaveAs Filename:="https:// blah /bla". ...

Hi, I just tried some kind of Add-in (VBA Code, free test version) that provides some help when writing code (I would use less than 5% of it, and the way to start a class in really great by the way). The only feature I love and would like to do on my own is the possibility to add what they...

Hi, I have a Macro spreadsheet which I am trying to share with other users via OneDrive. Sharing the Spreadsheet is no problem but the other users cannot use my macro to export to OneDrive because they do not have access to the "my" username file path; [CODE]Sheets("Export").Select...

Hi All, I have created a small excel sheet to embed into my web page, I have chosen to embed it using Onedrive as it seems the easiest way (copy and paste some iframe text) My problem has occurred when I created a simple 'Reset Button' which resets the form to blank, when I updated the...

=SUBSTITUTE(REPLACE(CELL("filename",C1),1,FIND("]",CELL("filename",C1)),""), "_test","") Hi guys I have this formula above here ^ which I use, to take a part of the name, from the worksheet name and display it in a cell. I upload this document to my MS OneDrive. I'd like to use this document...