o365

  1. FatalLordes

    Clear a cell when select ANY option from drop down?

    Morning all (well, it is morning here). So I'm using O365 and I'm wondering if there is any way to have excel clear a cell (lets say D16) when you make ANY selection from a drop down box located in another cell? And continuing on from that, as well as clearing a cell so that it contains...
  2. M

    Workbook Event Macros Triggering in Other Workbooks

    Hi I make fairly extensive use of workbook event macros such as Workbook_Open, _Activate, _SheetCalculate, _SheetChange, _SheetSelectionChange and Worksheet event macros such as Worksheet_Activate, _Change and _FollowHyperlink. These work great except occasionally and very intermittently and...
  3. T

    Macro to Save a copy of the Workbook to a specified location on OneDrive for multiple users.

    Our company uses Onedrive for our team file distribution. All work is done locally and then files are synced up when wifi is available. I have a few macros built in to our files to ready them for client distribution. The problem is sometimes the files get overwritten after the macros run and we...
  4. M

    Excel Co-authoring Upload Failed, Upload Blocked Errors

    From personal experience and reviewing this forum and even answers.microsoft.com, it seems that the co-authoring feature has some problems. I have two workbooks I share from Teams, both have macros and tables and one uses userforms for data entry. One, however, will experience random Upload...
  5. 7

    Passwords Quit Working

    I have several add-in/macro files that we deploy to users in our company. We have password protected them to prevent users from manipulating the code. The passwords have been in place for 10-15 years with no issue. A couple of weeks ago all of a sudden we developers can no longer open the VBA...
  6. P

    How to call the built-in Microsoft Translator with Excel VBA?

    Is there VBA code available that calls the translator, parses text, and then copies the text to a file or cell?
  7. M

    PowerPivot report - getting multiple filter values and calculating prior year data

    Thanks in advance! I'm creating a PowerPivot based report in Excel 365. I'm reporting actual quarterly sales data, performance against plan, and performance against prior year. There is a calendar table that links to the data table. I'm deriving prior year quarter by taking the value of the...
  8. J

    =UNIQUE coming to O365?

    Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe
  9. S

    Linking O365 to local excel files

    Hi all I'm looking at building a dashboard in O365 using the snazzy dynamic array formulas that I've been reading about, but I'm running into a theoretical hitch with how to accomplish something. I can schedule exports from our database to run automagically and save csvs with the data...
  10. C

    Auto-update Excel Total workbook from multiple Excel files in multiple Microsoft Teamexter

    I am looking for an automated solution to update One excel workbook on a weekly basis from 31 Microsoft Teams weekly workbooks. Each team has four members, a captain and three members. Each week a new workbook is created with 5 worksheets. The first worksheet is for Team Points. It gets...
  11. D

    Excel on Mac (O365) reading blank as zero on chart?

    Hi, does anyone know how to stop Excel (on a Mac using O365) from reading blanks as zeros?
  12. S

    MAXIFS alternative

    Hi, I have the following code which works on Office 365 using MAXIFS MAXIFS(Table1[Date],Table1[Name],D13,Table1[7 Dwarf],H13,Table1[Type],"<>"&"*Yes*")) Essentially it provides the maximum date that matched 3 criteria (name=D13, 7 dwarf = H13, type not contain Yes) Problem is I'm trying to...
  13. A

    Excel Online (O365) - Locking specific cells for editing by specific users or groups

    Hi all, It's possible to protect a workbook in such a way that only certain individuals are able to edit particular cells (Review tab, "Allow Users to Edit Ranges", and so on) however uploading this spreadsheet to my organisations O365 results in Excel Online seemingly ignoring these...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top