upgrade

Hi all, I seek your help again. I have this VBA: Sheets("Data_analysis").Select Set pvFld = ActiveSheet.PivotTables("Data_analysis").PivotFields("Entered on") strFilter = ActiveWorkbook.Sheets("MAIN").Range("C3").Value pvFld.PivotFilters.Add2 xlCaptionEquals, , strFilter It worked...

Hello, I am trying to create a tool which dependent on year, will tell me whether to upgrade a phone or repair. I have go to it work with the year so that it either returns "repair and Replace" dependent on year... but i want to incorporate an and statement in this. the statement below is...

Hello In Column Meter Type I have the following formula =IF(AA2="LARGE",AND(AC2={"BASIC","MRIM"}),"Meter Requires Upgrade") What I am trying to say is that if Column Classification contains the value "LARGE" AND column Meter Installation Code Contains the value "BASIC" OR "MRIM" then mark...

I have a workbook that was written in 32bit Excel and I'm trying to upgrade these sheets to work for 64 bit excel. The code that I need l find and replace is the following: find = "Private Declare Function", replace = "Private Declare PtrSafe Function". Problem is when I open the 32 bit sheet I...

Hello, I need help with the following diagnosis and a modification to an existing formula. Here is the table I am working with: <tbody> A B C D E F G H I J K L M N O P Q 1 Upgrade 1 Upgrade 2 Upgrade 3 # employees # months Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 2 May 3 3...

Hi Guys, At wok ad we just upgraded to Office 365, the code below worked great before upgrade, but now I get a compile error to find the project or library on the word "Format" on the "sname" line. It basically formats the date (A4) in a cell copies it and merges it with AM or PM from B4 2 on...

In my problem, I have two variables I am comparing--A and B. I would like to create a function that compares A and B for 1 of 3 possible combinations. If A = B, I want a "" value returned; if A>B, I want "Upgrade" returned; and lastly, if A<B, I want "Downgrade" returned. I know this is a...

When upgrading from Excel 2010 to 2016, I am receiving the following error message: Excel couldn't upgrade the Data Model in this workbook. It's been reverted to the previous version. I did a search and one recommendation was to first upgrade from 2010 to 2013 and from 2013 to 2016. I was...

How can I limit notifications to only when I receive a PM. I really don't care to receive notifications when someone quotes my thread or likes my thread. These are an annoying addition to the last upgrade. I will go to settings to see if anyone has responded to a thread that I have subscribed...

I have 365 business premium and don't have the power pivot and other BI. Can I upgrade or do I have to set up another account and purchase 365 proplus? Can I upgrade my whole 365 business premium to proplus?

A year or two ago I bought the newest Excel software. Unfortunately, the new software is incompatible with the all the VBA code I've been developing over many years - i.e. the computer crashes every other time I run a simulation that works fine with the old stuff. I use the old stuff at work so...

When my company upgrades MS Office, I lose all my macros and QA toolbar icons in Excel. Is there a way to preserve them before an upgrade? Example, when we went from 2007 to 2010, my macros and QA toolbars reverted to default. Same thing when we went from 2010 to 2013

Hi, Up until a week ago my company used Excel 2013 but we have now been upgraded to Office 365 with Excel 2016. Yay! A year ago I built an analysis template with accumulated weekly sales data with the power pivot addin, and had to upgrade the model to be able to use the report with the new...

My company want to upgrade CPU, will that affect the macros that stored in PERSONAL.XLSB ? Will I have to re-record the macro again ? If there is upgrade of Excel version, will there be any compatibility issues ? What other things I need to take care for the changes ? Hopefully, the...

Hi, All... I am coordinating an upcoming upgrade in our department from Office2007 (skipping over Office2010 completely) to Office2016 for about 220 people. Some of our folks still have the old Personal.xls file in their XLStart folder, left over from Office2003 we had years ago. Everybody...

Hello, I was just recently upgraded from Office 2010 to 2013. I had several macros in 2010 that I used regularly that are no longer working. One of the reasons has been resolved -> it was having issues with date formats or recognizing dates even when manually typing them in. This was fixed...