o365

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...

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...

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...

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...

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

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...

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

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...

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...

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

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...

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...