office

  1. T

    How to change or replace multiple cell name in Microsoft Excel chronologically?

    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"...
  2. E

    Query in excel to Outlook mail take rows with name until next name

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

    is it possible to auto create many records

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

    Office Scripts Optimization

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

    Office 64 vs 32bit

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

    Error on Closing PowerPoint Presentation from Excel-VBA

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

    Change Office display language with VBA

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

    Timeline slicer: 2x click total of the pivot provides too many lines

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

    New computer, new Office

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

    XLOOKUP in Excel 2019

    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?
  11. kelly mort

    General knowledge on datepicker - 32 bits vs 64 bits compatibility

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

    What would be the alternative for 'Office.CommandBar' in Office 365 for MS Access

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

    32 to 64 bit

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

    Goal Seek not working in my office 365

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

    Split Access Database Keeps Crashing

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

    ifs() not in office 365

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

    Sheet Compatibility

    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?
  18. L

    window menu in old excel version

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

    Programmatic access to Office VBA project in Office 365

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

    Why does FUNCRES.XLAM open in a seperate window when I open an xlsm workbook

    I know what the FUNCRESS.XLAM sheet does, I have used it for a long time. In the past when opening an xlsm workbook only the workbook opened. Recently with no changes by me, a second window for FUNCRES.XLAM opens. This is true for existing and new workbooks. If I close it the entire workbook...

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