Tag Archives: microsoft
How to disable MFA and Microsoft Authenticator for all users
Hello
Please i would like to know how to disable MFA and Microsoft authenticator for all users within the tenant?
Hello Please i would like to know how to disable MFA and Microsoft authenticator for all users within the tenant? Read More
Alphabetize a whole spreadsheet with A column
I want to alphabetize a spreadsheet using the values in column A but don’t want the rest of the spreadsheet to be left in original position. How can I accomplish this?
I want to alphabetize a spreadsheet using the values in column A but don’t want the rest of the spreadsheet to be left in original position. How can I accomplish this? Read More
I never received my Roblox gift card
It’s been 2 days and I have never received my roblox gift card.
It’s been 2 days and I have never received my roblox gift card. Read More
Using Array Formula C(olumns) and R(ows) times in excel formula
I’m looking to expand a formula that can accommodate building scenarios over a span of 5 years (columns) and 10 cases (rows).
I can effectively handle the setup for one row and generate the outcomes across various years.
I can then drag the formula down to address the rest of the cases.
However, the cases might change dynamically, and I need an adaptable and general solution. Can anyone provide some guidance on this?
I’ve attached a spreadsheet where I try to explain the concept in more detail.
I’m looking to expand a formula that can accommodate building scenarios over a span of 5 years (columns) and 10 cases (rows).I can effectively handle the setup for one row and generate the outcomes across various years.I can then drag the formula down to address the rest of the cases. However, the cases might change dynamically, and I need an adaptable and general solution. Can anyone provide some guidance on this? I’ve attached a spreadsheet where I try to explain the concept in more detail. Read More
My video and audio is playing in slow motion with buzzing sound
Hi everyone, today my younger brother was working with my PC. Suddenly he pressed an unknown key. After that, every audio and video plays in slow motion with a buzzing sound. I work with a DAW (Digital Audio Workstation) also playing audio in slow motion. What should I do? Please help as soon as you can, I have a lot of work for my project. Thanks…
Hi everyone, today my younger brother was working with my PC. Suddenly he pressed an unknown key. After that, every audio and video plays in slow motion with a buzzing sound. I work with a DAW (Digital Audio Workstation) also playing audio in slow motion. What should I do? Please help as soon as you can, I have a lot of work for my project. Thanks… Read More
Issue Converting (Date) HH:MM:SS to Minutes Corrected
Linked to: Issue Converting (Date) HH:MM:SS to Minutes – Microsoft Community Hub
Apologies, because I changed the formatting, the formula didn’t account for the missing time
Custom format [h]:mm:ss
There is also a date in there I don’t understand why
But that’s accounting for some of the missed time
Please advise
Linked to: Issue Converting (Date) HH:MM:SS to Minutes – Microsoft Community HubApologies, because I changed the formatting, the formula didn’t account for the missing timeCustom format [h]:mm:ssThere is also a date in there I don’t understand whyBut that’s accounting for some of the missed timePlease advise Read More
Unreliable Saving in Microsoft Forms and Limitations on number of questions
I’m repeatedly facing issues with Microsoft Forms where it fails to save my work on both the web and application versions, leading to significant loss of effort. To make matters worse, after painstakingly creating 160 questions, I was blocked with a message stating, “This form has the maximum number of questions,” contradicting the stated 200-question limit on the website. It is unacceptable that such critical limits are not communicated clearly and upfront, causing unnecessary hassle and wasted time.
Can anyone explain why these discrepancies exist and how to avoid such setbacks? I’m very disappointed and need a reliable solution.
I’m repeatedly facing issues with Microsoft Forms where it fails to save my work on both the web and application versions, leading to significant loss of effort. To make matters worse, after painstakingly creating 160 questions, I was blocked with a message stating, “This form has the maximum number of questions,” contradicting the stated 200-question limit on the website. It is unacceptable that such critical limits are not communicated clearly and upfront, causing unnecessary hassle and wasted time.Can anyone explain why these discrepancies exist and how to avoid such setbacks? I’m very disappointed and need a reliable solution. Read More
I have an issue with a Power App template.
Among the available templates to use to start generating Power Apps is one entitled “Power Apps Training”, This looks like a tool were someone can learn Power Apps in a psudo-tutoral where you just press F5 to switch from preview mode to editing mode. It has instructions and exercises included.
The problem is on the page L06_Rules
On this page, there is a slider along with a button like this:
At this point, to ensure I am not going to lose the text of this post, I will post and edit ore afterwards
Among the available templates to use to start generating Power Apps is one entitled “Power Apps Training”, This looks like a tool were someone can learn Power Apps in a psudo-tutoral where you just press F5 to switch from preview mode to editing mode. It has instructions and exercises included. The problem is on the page L06_Rules On this page, there is a slider along with a button like this: At this point, to ensure I am not going to lose the text of this post, I will post and edit ore afterwards Read More
Image created by Dalle -3 got turbo 4 IOS anyone know where the downloaded location is? Currently it
Where do these land in IOS if nowhere I am canceling subscription I know it’s new technology but this seems like an ez code fix 🤷🏼:male_sign::thumbs_up:
Where do these land in IOS if nowhere I am canceling subscription I know it’s new technology but this seems like an ez code fix 🤷🏼:male_sign::thumbs_up: Read More
Currency Separator
Can this separator be only for thousands or can it be changed as it is done for Indian currency? For Indian currency, the numbers go in thousands up to 100,000 which is called one lakh. For example, 150,000 rupees becomes 1.5 lakh rupees, written as ₹1,50,000 or INR 1,50,000. Then 1,00,00,000 (one hundred lakhs) is one crore. It is written as 1,00,00,000 with the local 2,2,3 style of digit group separators. Can this type of separators be created in Excel?
Can this separator be only for thousands or can it be changed as it is done for Indian currency? For Indian currency, the numbers go in thousands up to 100,000 which is called one lakh. For example, 150,000 rupees becomes 1.5 lakh rupees, written as ₹1,50,000 or INR 1,50,000. Then 1,00,00,000 (one hundred lakhs) is one crore. It is written as 1,00,00,000 with the local 2,2,3 style of digit group separators. Can this type of separators be created in Excel? Read More
Create a chart based on multiple datas in the same row
Dear Community,
My question is (I believe) very simple to answer, but somehow being pretty new to Excel I cannot figure out how to solve it.
I want to create a (pie) chart based on multiple datas that are all in the same row, but different columns.
As you can see in the picture, I want to create a pie chart that shows me how my expenses, which are divided in 7 categories, are actually split. I tried to create it selecting the name of the category and its expense by holding cmd/crtl, but when I create the chart it only considers the “Food” category and its price. As you can see from the columns highlighted in green, I am actually selecting all those cells, but somehow it does not work.
I overcame the problem once by listing the categories and the prices in the same columns, but in different rows and it worked. But I cannot believe that it’s not possible if the datas are on the same row, there must be a way, right?!
I want to mention that I have a Mac and use Excel online, in case this influences it.
I look forward to hearing from some expert 😉
Thank you in advance
Dear Community,My question is (I believe) very simple to answer, but somehow being pretty new to Excel I cannot figure out how to solve it. I want to create a (pie) chart based on multiple datas that are all in the same row, but different columns. As you can see in the picture, I want to create a pie chart that shows me how my expenses, which are divided in 7 categories, are actually split. I tried to create it selecting the name of the category and its expense by holding cmd/crtl, but when I create the chart it only considers the “Food” category and its price. As you can see from the columns highlighted in green, I am actually selecting all those cells, but somehow it does not work.I overcame the problem once by listing the categories and the prices in the same columns, but in different rows and it worked. But I cannot believe that it’s not possible if the datas are on the same row, there must be a way, right?!I want to mention that I have a Mac and use Excel online, in case this influences it. I look forward to hearing from some expert ;)Thank you in advance Read More
Formatting Issues
Hello – I don’t know how, but I changed something in my document and now every time I type or try to delete i get red type with a line through it – wont let me delete or backspace to delete –
Hello – I don’t know how, but I changed something in my document and now every time I type or try to delete i get red type with a line through it – wont let me delete or backspace to delete – Read More
Latest Dev Update will not download. ISO will not install.
Windows Update reports an update is available (26060) but the download will not start. I also tried to use the ISO for the same version. When I run Setup, it starts, checks for updates and then just quits. Do I have to reset the current version to overcome this?
Windows Update reports an update is available (26060) but the download will not start. I also tried to use the ISO for the same version. When I run Setup, it starts, checks for updates and then just quits. Do I have to reset the current version to overcome this? Read More
Issue Converting (Date) HH:MM:SS to Minutes
Trying to convert HH:MM:SS to minutes
Some cells have dates not needed
See attached example
Thank you for your time
Trying to convert HH:MM:SS to minutesSome cells have dates not neededSee attached exampleThank you for your time Read More
Regression with a variable that has 20 different categories
I need to run a regression with a variable that has 20 different categories. I figured i could make a dummy with 20 different columns with 1 and 0. However when im running my regression i can only use 16 X variables. Does anyone know how i can fix this?
I need to run a regression with a variable that has 20 different categories. I figured i could make a dummy with 20 different columns with 1 and 0. However when im running my regression i can only use 16 X variables. Does anyone know how i can fix this? Read More
Automate Ribbon instead VBA script
Glad find useful resource where can share my best practices , in my case I had data present sr number , emp name , sales , order date , month, week and email id along with other fields untill BB column of excel now wish to see the data in pivot normally we use pivotable manually do a pivot in our excel for me find this call Automate ( Script ) loved to use this used below code find useful result
function main(workbook: ExcelScript.Workbook) {
// Define the range
let dataSheet = workbook.getActiveWorksheet();
let dataRange = dataSheet.getRange(“A1:BB50”);
// Read data into a 2D array
let dataArray = dataRange.getValues();
// Initialize variables for summary
let summary = {};
// Loop through the data to calculate sales by month
dataArray.forEach(row => {
let month = row[0]; // Assuming the month is in the first column
let sales = row[1]; // Assuming sales data is in the second column
if (!summary[month]) {
summary[month] = sales;
} else {
summary[month] += sales;
}
});
// Prepare the summary data for output
let summaryArray = [];
for (let month in summary) {
summaryArray.push([month, summary[month]]);
}
// Output the summary to a new worksheet
let summarySheet = workbook.addWorksheet(“Summary”);
let summaryRange = summarySheet.getRange(“A1:B” + (summaryArray.length + 1));
summary
Range.setValues(summaryArray);
}
If you want to leverage this automate script you can do this is available in my premium account of office 365 you can check :white_heavy_check_mark: yours if it’s available in ribbon :ribbon:
Please note – it’s not macro
Glad find useful resource where can share my best practices , in my case I had data present sr number , emp name , sales , order date , month, week and email id along with other fields untill BB column of excel now wish to see the data in pivot normally we use pivotable manually do a pivot in our excel for me find this call Automate ( Script ) loved to use this used below code find useful result function main(workbook: ExcelScript.Workbook) { // Define the range let dataSheet = workbook.getActiveWorksheet(); let dataRange = dataSheet.getRange(“A1:BB50”); // Read data into a 2D array let dataArray = dataRange.getValues(); // Initialize variables for summary let summary = {}; // Loop through the data to calculate sales by month dataArray.forEach(row => { let month = row[0]; // Assuming the month is in the first column let sales = row[1]; // Assuming sales data is in the second column if (!summary[month]) { summary[month] = sales; } else { summary[month] += sales; } }); // Prepare the summary data for output let summaryArray = []; for (let month in summary) { summaryArray.push([month, summary[month]]); } // Output the summary to a new worksheet let summarySheet = workbook.addWorksheet(“Summary”); let summaryRange = summarySheet.getRange(“A1:B” + (summaryArray.length + 1)); summaryRange.setValues(summaryArray);} If you want to leverage this automate script you can do this is available in my premium account of office 365 you can check :white_heavy_check_mark: yours if it’s available in ribbon :ribbon: Please note – it’s not macro Read More
I can’t change the beginning part
Hello
I see this all the time on the start page, I want another site to open but I couldn’t. how can I do that?
Hello I see this all the time on the start page, I want another site to open but I couldn’t. how can I do that? Read More
Shortcut to zoom in at 90% in microsoft excel for all workbooks without using VBA
Is there any way to zoom at specifically 90% or any other % with using keyboard shortcut keys and not using VBA?
For now, I have kept zoom in my quick access toolbar and manually add 90% at the custom field.
Is there any way to zoom at specifically 90% or any other % with using keyboard shortcut keys and not using VBA?For now, I have kept zoom in my quick access toolbar and manually add 90% at the custom field. Read More
SMTP Settings to enable other app (Acronis TI) to send email via M365
Hi all,
I have recently moved from M365 Personal to Business. I also use Acronis True Image which needs the following SMTP settings to send notifications by email:
Server settings:
Outgoing mail server (SMTP) name
Port
Encryption
SMTP authorisation:
Username and password
Optional – Log on to incoming mail server:
POP3 server and Port
I have found various (conflicting) settings on the web (including adding Authenticated SMTP in the M365 Mail settings for the user) but none work.
Can anyone help?
Hi all,I have recently moved from M365 Personal to Business. I also use Acronis True Image which needs the following SMTP settings to send notifications by email:Server settings:Outgoing mail server (SMTP) namePortEncryption SMTP authorisation:Username and passwordOptional – Log on to incoming mail server:POP3 server and PortI have found various (conflicting) settings on the web (including adding Authenticated SMTP in the M365 Mail settings for the user) but none work.Can anyone help? Read More