office 365

My company converted to Office 365 today. I use a lot of external data connections in my Excel files. After the conversion none of these work. Most are connecting to a server vs a mapped drive. Is there a way to get these to work without redoing everything? Thanks! Crystal

Can someone please help me? After I upgrade Office from 2010 to Office 365, all the codes become very slow. I'm looking into the causes. I came across this really simple codes and pulled out a section. I wanted to ask all of you experts why these simple codes would take such a long time to run...

Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...

Hello I wondered if you could help. I have just started to learn how to use VBA to help with data management in excel. I'm using excel office 365 on windows 10. I managed to create a macro that processes the raw data into a pivot table filtered to a set format (lets call this sheet 1). Within...

Hi, It's my first post here. I have 2 tables in Excel that come from VBA data extraction from some other software. I’d like for the common values in the NAME column on each table to be linked, meaning : if, for instance, I replaced ABC02 in the second table with ABC03 then the first table’s...

Hello everyone, I have a workbook that I built in Excel 2013 which contains some VBA code requiring programmatic access. I sent the sheet to a user who has Office 365 along with instructions to allow programmatic access that I found at...

Trying to extract SOFR rates and dates from US Fed Bank website https://apps.newyorkfed.org/markets/autorates/rates-search-page?rateType=R3, using excel sheet to drive the dates (basically all data from 1st April 2019 to present), back into the same excel sheet to link into other formulas and...

Cross-post! CloneApp - this is a software that allows you to copy/backup the desired registry branches. Want to understand how from the registry backup what I need (I just do not know where to look, there are a lot of things written) !? Settings - ContextMenuCell, ContextMenuPly...

I'm very new to VBA and found a code online that sends emails to multiple recipients but can only attach 1 file per email. I cannot find a code that works wherein it goes to a specific folder and attaches all PDF files that are stored in the folder and goes to a different folder and does the...

For example, let's say I'm in an Excel worksheet and use the ⌘⇧K shortcut for the group rows/columns action. A menu pops up with two radio buttons, the first for the option to group by "Rows" and the second for the option to group by "Columns". (The former radio button is selected be default.)...

I have some code going through 20 rows and 4 columns copying and clearing each line from a selected point to "insert" a row without actually inserting. I can't actually insert the row and I'm working in merged cells. I'm also moving images in a specific column but that doesn't seem to be the...

Hi I have the code below in Office 365. The issue that I have are that it didn't want to copy the format correct, even if I add the following code. Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False If I run this code...

I have the professional enterprise version of office 365 that I use for work. However I would like to purchase a home version with the full Power Query and Power Pivot capabilities. Does anyone know what version I should buy. Does it have to be a business version?

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

Hi I have a macro, which opens another Excel file from Sharepoint and writes data in it. To write-enable the file, I use "ActiveWorkbook.LockServerFile". This works fine with Office 2016. Now we are changing gradually to Office 365, so some computers are equipped with with Office 2016 and some...

Dear All, I have a problem with refreshing linked table (from Excel sheet where I have about 150.000 rows and 11 columns of data) to Power pivot model. It takes a quite long time. So, I am using Office 365 ProPlus, version 1804 (Build 9226.2156). In my VBA code I have the following...

Dear All, I have a problem with refreshing linked table (from Excel sheet where I have about 150.000 rows and 11 columns of data) to Power pivot model. It takes a quite long time. So, I am using Office 365 ProPlus, version 1804 (Build 9226.2156). In my VBA code I have the following...

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've built a spreadsheet which I'd now like to roll out for simultaneous use by individuals throughout the business. It's built on Excel 2016, & I know I have access to Office 365 (although I've not actually used it yet). Is there a way to convert a 2016 to 365? for use in this manner? Thanks Jon

Hi All: I need some help with something. I have our Purchases in a Workbook with a sheet for every month and a workbook for every year. I have them available in a shared drive so they are accessible to everybody on the network. I'm having a problem with locking them but still allowing them to...