office 365

My organization uses Office 365. I created a second workbook by copying a first workbook. But the problem is the ribbons of the respective workbooks are not independent, instead, changing the ribbon in workbook 1 changes the ribbon in workbook 2 and vica versa. That is not what I want, I want...

Hi all, I have found several "old" posts on different fora stating code for making the mouse wheel scroll in listboxes on a userform. However... they are all written in a time pre-64-bits and do not work on my "modern" system. Can anybody help me out with a set of modules and codes to make it...

Hi Guys, I have a Excel file which has a macro to open multiple spreadsheets based on the location specified within macro. I used this file (and macro) for about a year and it was all good until we migrated to Windows 10 and Office 365. All other macros seem to be fine but the most important...

My company just converted to the new office 365. I noticed that some of the VBA codes in my workbooks are executing very slow compared to the previous version :mad: I'm wondering why this is and is it a way around it? Are there new features in the new version that may affect VBA code execution...

I am building a Access Web app in office 365 (something I have never done before). I think by default the tables created in the app are stored in sql server azure. Can I specify or define the names of the sql server azure and link to our on-site sql server? I am trying to sync the data tables...

Using Excel Office 365, I'm trying to freeze the top 4 rows on one tab. I select cell A5, go to View Tab, Window Grouping, Freeze Panes Pull Down, Freeze Panes. The result is that the top 4 rows indeed freeze, however, they are duplicated on the scrolling window below, and if I click in a...

I created a scheduling page with everyday, added a tab for the data, then used a list to do a drop down for the times. On the other tabs (monday - friday), I wan't to take the hours from that day on the master sheet and show on the day's tab. Then on let's say monday. If they have 6 hours and...

Hello everybody. I have been going crazy over this and although there are multiple threads regarding this problem none of them have helped so far. The Problem: There is a destination sheet that collects data from multiple Source sheets (12 atm, but may become more). The links have mostly been...

My school district is moving from Google Apps to Office 365 and I am trying to find out if Office 365 will be able to accomplish a task. In Google forms I created a survey and after someone completed the survey a "script" was automatically run and it would take the responses and place it into...