office

Hi - I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation. Problem: I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...

I have 5 main sheets and want to freeze pane lines starting from sheet 6, row 7, column 2. What do I have to do? Thank you.

I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...

Dear all, Im trying to avoid sending mails out every week with new tasks for people. Therefor i try to create a code that can look at my query data and sent it to the correct person in outlook. I would like to make a code which takes the header and table data for rows with specific name and...

I have a excel sheet with a series of random numbers, for each cell in this series I need it to create a series of numbers in a second sheet based on a single cell in the series in the first sheet. For example if a cell in first sheet is 144;I would like to create 144 new rows on second sheet...

Hello all, I have a script I made in Excel Web to automate a task when adding data to the spreadsheet. It works fine and has no issues but it's a little bit of a delay from when the user clicks the button and the data populates on the sheet. Any ideas on how can I help speed up the script...

Hi, I have some questions for those who found themselves in this situation: We've been working on Office 32bit for a few years, and we used form controlls like Treeview, Listview and other more advanced controlls, just to find out that they are not available on Office 64, and now IT is kind of...

Hey Everyone, so i have the following code in order to open a powerpoint presentation which i have embedded into excel, save that powerpoint under a new name to a filepath and then open that powerpoint (so that the new saved powerpoint copy is edited and not the embedded object) Sub...

Hi Guys, Small issue yet annoying: I use Excel/VBA in different languages and I'd like a solution where I run a VBA code and display language updates automatically (let's say from English to German). I'm talking about this setting in Excel: I assume it can be done with some API or editing...

Hi, I have set up a timeline slicer on a pivot for a tool in Office 365. The users use Office 2013 and the pivot behaves exactly the same on both versions: if we put the slicer on today's date, we have the result of all the lines of today. But we need more than that. In my version, if I double...

Hi folks, I bought myself a new Mac Book. My old Office 2011 is out of installs and it looks like Office 2019 is where I'm going. But I do have a couple of questions. Does anyone who has experience with 2019 know if: 1) does it support VBA (in memory of 2008 :) ) 2) is the MacScript command...

When will XLOOKUP and the other new functions be added into Excel Office 365 or Excel 2019? Will I have to know it for the test?

So I developed a few problems with datepicker in excel currently then I have to do more reading about that object.What I found was that it does not work well on the 64 bits office versions.When I tried testing it on 64 bits office version, it said it couldn't load the object. Then when I went to...

Hi, I have below lines in my code. Dim MyOrig As Office.CommandBar Set MyOrig = CommandBars("Menu Bar") Dim MyMAIN As CommandBar Set MyMAIN = CommandBars.ActiveMenuBar What would be the alternative for 'Office.CommandBar' in Office 365 for MS Access. This code is written in older version of...

Someone has asked if an App I have can work in their 64 bit Office. (I think it's the online one). I installed 64 bit office 2010 onto my laptop to find out. Running the xlsm file brings up a pile of problem but I did manage to alter all the Functions to ptrsafe Functions. Then there are lots...

Hello Evryone I have a problem in my office 365, in using goal seek When I use it, it change the set value by the value i has entered without changing the cell that must be changed This is an exemple A1 = 1 / A2= 2/ A3= A1+A2=3 (My goal is to have 100 in cell A3 by changing A1=> The...

We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit. We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...

Hi I am reading that ifs() is in excel 2016. I have office 356 and I thought it is updated version of 2016. Thank you.

I have a .xls spreadsheet with macros. The macros run perfectly in Windows 10 Office Excel 16 but not in Office Excel 2019 for MAC. Do I have to convert this sheet to run the macros properly in Office Excel 2019 for MAC?

Hi I am watching the video below and in minute 2:00 he went to Window tab in the menu to find out which excel files are opened. I am using office 365, where I can find that option? Thank you very much. https://www.youtube.com/watch?v=-foPogO3QNE