version

Recently I upgraded from Office Professional 2003 to Office Professional 2013 by purchasing it from Ebay. I decided to leave my old 2003 installed; so both are installed. Excel 2013 works very well; no problems there. But somehow in the process it seems that my old Excel 2003 got renamed as...

I've got a weird problem. I have an XLSM file (with some VBA) that works fine 95% of the time. The other 5%, it crashes on opening, and then will continue to crash on opening - until I open and save the file with a different version of Excel (2016-32bit). Anyone ever resolve this issue? Even...

Greetings All, I have a school the runs 30+ computers. Recently, we had a lot of them stolen. I would like to have my inventory not only list the SN of each, but also a lot of the fine details that help recover these items if it occurs again. I am a start-up school, money is very tight, so...

Hi, I have a problem with a Index and Match formula with multiple criteria (array formula). I have tried two different versions but neither of them work, could anybody please have a look at this? I have also uploaded the file to my dropbox if you want to see the real file. Version 1...

Guys, For the old version of MS Access, I remember someone develope some OCX or something related that was possible incorporate a side Menu. Is there a way we implement the same thing on Access 2010 version onwards?

Good Morning to everybody, I'm writing you here because I didn't found anything regarding the "remote update" of an excel file. I would like to offer to my client a feture that when they open my excel file the macro check on a server ftp/sftp or web if there is any new version. The macro...

Hi everyone, I had an issue with a macro in my workbook, which is now resolved. However, I can not get the margins, headers and overall formatting of my document back to the way it was. I've re-created it, tried it from another version of excel, even a different pc but the margins are just not...

Hello all, i installed Ejhtml4 and selected this in the add-in under option but nothing seem show. Does it not work with this version of Excel or is there another recommended one?

Hello Gurus, Working in Excel 2007. I'm attempting to compare 2 lists located on separate sheets of the same workbook. The comparison should be based on columns A B & C on both sheets with one twist, from this comparison I would like to generate a new list, to be located on a third sheet, of...

Is there a way I can get some text from a webpage? The page in question is an internal intranet page, so I can't paste the URL, but it has text which states 'Current Version:' and I need to get the text after that phrase if it's possible.

I can find a lot of solutions that will highlight the first incidence of a given value in each column but I am looking for a version that will only highlight one incidence in the entire array. The current version is as follows (array is B2:FQ450) =COUNTIF($B$2:B2,B2)=1

Hi all, I have a button with a code to save on SharePoint (SaveAs) and it all works fine. When the process is done and the user wants to close the workbook, the system would ask if they want to save it (it shouldn’t ask as the file is just saved and no changes been done since then?) and when...

I am running Excel for Mac version 16.11.1 (180319) on macOS High Sierra version 10.13.3. I have written a simple test macro that only does this: Sub RngTest() Dim rng As Range On Error Resume Next Set rng = Application.InputBox(prompt:="Title", Type:=8) End Sub When I run the RngTest...

So turns out that since I have a subscription download of Office Pro Plus 2016, the version is ancient and there's a lot of new updates made that I'd like to install. How do I do that? File -> Account -> Office Updates -> Update Options -> Update Now says I have the newest version while clearly...

Hello i have a sheet run well on Excel 1997 version. When I run it on Excel 2003 version i have this message error: Run-time error '-2147024809 (80070057)' : item with the specified name wasn't found pls, can you help me : my peace of code is below: Sheets("Pz1").Select...

Our company is going from Excel 2010 to 2013 and this will take some time so we will have people on both versions for a while. I have been upgraded so I have 2013 and the higher version of the office Reference library (15) is sticking itself into anything I open. Can I just take this out...

Hi, I have a question. I have an excel file with a long list of projects with versions of this list and I want to delete or hide all projects but the latest version. Is there a way to do this? Below an example of the type over versioning. The idea is that I want to have a filter that takes...

Hi, in another thread I outlined problems running version 2007. To resolve tehm I dexcided to buy Office 2010 hoping that would fix things. I've installed it but trouble straight away... e.g. The code in this project must be updated for use on 64-bit systems. Please review and update Declare...

Hi All, I did an Excel update for MAC yesterday and I am having a few performance issues. I am using version 16.9 and my question is, can I roll back to the previous version? I have office 360 and I went on the website to see if there was a list of versions that I could choose from but I was...

I have a spreadsheet with c20 sheets in it and a lot of VB code. I want to have a macro that will save a copy of the spreadsheet (with name = value in cell B3 of sheet 1) in the folder: G:\Indv\EQA\Rec. I'd also like to have the new version saved without the VB code in it, and as an xlsx...