Stop Microsoft's nagware pop ups
Once more, I'm on a new computer which has reset all of Microsoft's nagware pop ups that remind me how to use a product I've used for literal decades. "Did you know you can click here and do this". "I see you went to a new menu, did you know you could see ____ in this menu but you can't actually see it because this intrusive pop up is blocking it?" "Here is another pop up that deselected the cell you were currently typing in and you didn't notice is for 5 minutes so you have to redo everything you just worked on. Sucks to be you." How the hell do I get this nagware garbage to go away forever and never, ever, ever, ever, ever, ever come back?!
Excel Ref Error online but not on desktop when linking to another table
Hi, So I have 2 seperate spreadsheets and I am linking Table1 from Spreadsheet1 onto Spreadsheet 2. When I do this with Excel desktop it is able to import the data without any issues. The new table in Spreadsheet 2 automatically updates as I enter data into Table 1. Both of these sheet files sit on my one drive. Now when I save, close the files and open up the excel files online via sharepoint, there is a Ref error in the Spreadsheet 2. The formula has changed to the sharepoint location which I assume is correct. Can somebody please advise?Adding data ONLY when two cells match across sheets...
Hi all, Apologies: this is complicated... I'm working across x2 sheets in an Excel book. On sheet 2, I have my export page, where I paste the uploaded data for it to fill in sheet 1. On sheet 1, I have the historical data which I need to add to weekly. Sheet 2: Export Page including current formula (based on a working formula on another sheet we use. I need both forename and surname to match on the next page, and automatically paste columns C and D if/when/where they do, then tell me where any names have been missed (new students, etc.) so I can add them to the doc. So if A2 and B2 were on A6 and B6 on sheet 1, that is where the data (C2 and D2) would be pasted, to ensure that the student retains their own points balances. Sheet 1: Overview Page - I intend on the above columns C and D then being put into columns J and K on this page. I'll then just copy and paste the data across into the correct week following analysis, ready for the formula to re-populate those cells with the coming week's data. I switched forename and surname around for readability but can return if that makes it easier (for GDPR purposes, I have removed all names). The formula there had green "Yes"s through the page when I used the original data. When I have gone to update today, everything is a red "No", as you can see, so I clearly don't have the right formulas!! Appreciate your help, as I've been working on this for a couple of weeks now and just can't figure it out!! The formula on the other sheet that I was trying to work from was: =IF(COUNTIF(Table1[@[Name and tutor]],A2)=1,"Y","N")Shapes Moving Even When set to Do Not Move
I use Excel 365 Enterprise 4 edition. I created a file that is stored on a Teams site that contains shapes I use as buttons for my macros. Every time I open the file the shapes have moved and/or resized and I can't figure out how to prevent this. I have the shapes set to Don't move or size with cells set on each one of them. Users are not moving them. No one is playing any pranks, I wish they were it be a lot easier to fix. Anyone have any ideas?
How can I return one unique match
Hello I am trying to match participant data for work, based on multiple criteria, and I want it to return me an ID number that has not yet been matched. So far I understand that me using the following equation will only return me the first match =INDEX($A$478:$A$9549,MATCH(1,(C2=$C$478:$C$9549)*(D2=$D$478:$D$9549)*(E2=$E$478:$E$9549),0)) Whereas using =UNIQUE(FILTER($A$478:$A$9549,(C2=$C$478:$C$9549)*(D2=$D$478:$D$9549)*(E2=$E$478:$E$9549))) will return me all the unique matches for one ID However, I just want to match up each ID (based on matching three criteria above) with another ID that has not yet been matched. If there is no unique, not yet used, match, would it just be able to return N/A? Thank you for any help you can provide!
Excel Script - not calculating as expected
Hi folks....I'm hoping somebody can shed a bit of light on what I'm doing wrong here. We have a simple holiday tracker - it has a small amount of VBA in it which I figured would be a good candidate to migrate over to an Office/Excel script so that it could work in the browser version of the application. The file has over 300 columns, a column for each day of the year. All the macro does is move the view forwards or backwards in the year by toggling the visibility of the column. Above each column, in a hidden row is a simple formula which results in either Show or Hide depending on the current month. It has 2 buttons, one to increease the month number and one to reduce it. The show/hide value updates based on this number. The VBA version works pretty well but given it's fairly basic, I assumed it would be a good cadidate for my learning in Excelscripts! So after much effort I came up with the script below..... function main(workbook: ExcelScript.Workbook) { // Get the active cell and worksheet. const CalcMode = workbook.getApplication().getCalculationMode(); console.log(CalcMode); // TODO: Write code or use the Insert action button below. let ws = workbook.getWorksheet("Refs"); let rng = ws.getRange("rngCurMonth"); let wsY = workbook.getWorksheet("Year"); let rngY = wsY.getRange("rngShowHide"); let rngYVals = rngY.getValues(); let colCount: number = rngY.getColumnCount(); let monthNum: number = rng.getValue(); wsY.getRange("B:NG").setColumnHidden(true); if (monthNum > 1) { monthNum = monthNum - 1; rng.setValue(monthNum); workbook.getApplication().calculate(ExcelScript.CalculationType.full); monthNum = rng.getCell().getValue(); console.log(monthNum); for (let coll = 0; coll <= colCount; coll++) { //console.log( coll + " is " +rngYVals[0][coll]); if (rngYVals[0][coll] == "Show") { rngY.getColumn((coll)).setColumnHidden(false); } } } } I have linked this script to a button. When it's clicked the value relating to the month number changes correctly. The script hides all the columns and then unhides the ones where the value is "Show". The problem is that the formula relating to this Show/Hide value only seems to update once the script has completed. It's not recalculating after the value is changed. I have added a line to try to force the recalc mid process, but it's not working. Any ideas? There are a few console.log lines in there which I need to take out, like the start where I'm checking that Excel is in automatic calc mode....which it is!! Also, after I set the monthNum variable, I have got the script to pull the value from the range holding the month number from the worksheet, to show that's it's updated correctly I'm stumped. I find it difficult to learn these scripts partially because the editor is woeful! Regards, Tony
