Tag Archives: microsoft
Lambda
I used this Lambda function:
“=LAMBDA(range,IFERROR(TOCOL(FILTER(‘3 times’!K3:CL3,(range=3))),””))(K4:CL4)” and it worked perfectly.
I then inserted it into name manger, created a name and it fails to work. It seems to input the wrong cell references?
I used this Lambda function:”=LAMBDA(range,IFERROR(TOCOL(FILTER(‘3 times’!K3:CL3,(range=3))),””))(K4:CL4)” and it worked perfectly.I then inserted it into name manger, created a name and it fails to work. It seems to input the wrong cell references? Read More
Balancing “Car Simulator 2” and Outlook: Tips for Productivity on and off the Road
Hey everyone,
While I’ve been diving into “Car Simulator 2” for some relaxation, I’m also knee-deep in Outlook for work. It got me thinking, how do you all balance gaming and productivity tools like Outlook? Any neat tricks for managing both efficiently? I’d love to hear your thoughts on staying organized whether you’re behind the wheel in the virtual world or tackling your inbox in the real one!
Looking forward to your insights!
Hey everyone,While I’ve been diving into “Car Simulator 2” for some relaxation, I’m also knee-deep in Outlook for work. It got me thinking, how do you all balance gaming and productivity tools like Outlook? Any neat tricks for managing both efficiently? I’d love to hear your thoughts on staying organized whether you’re behind the wheel in the virtual world or tackling your inbox in the real one!Looking forward to your insights! Read More
Header background is being applied intermittently using Site Script in communication site
Hello All,
The problem is that while I am using some of the verbs in conjunction with the “setSiteBranding” in the site script, the header background color is not always set.
I’ve noticed that the site template functions flawlessly when I apply it to an already-existing site, but it only occasionally—not always—works when I use it to create a new site.
Can anyone please assist me on this?
Hello All, The problem is that while I am using some of the verbs in conjunction with the “setSiteBranding” in the site script, the header background color is not always set. I’ve noticed that the site template functions flawlessly when I apply it to an already-existing site, but it only occasionally—not always—works when I use it to create a new site. Can anyone please assist me on this? Read More
Pivot Table SubTotal does not agree with simple SUM operation
I have created a pivot table using one table and a calculated column using Power Pivot. Field “Three+” is displaying correctly but the sub total is incorrect. The other fields are displaying correct subtotals.
What am I missing?
Thanks
Brad
I have created a pivot table using one table and a calculated column using Power Pivot. Field “Three+” is displaying correctly but the sub total is incorrect. The other fields are displaying correct subtotals.What am I missing?ThanksBrad Read More
Embed pdf from SharePoint library with default zoom level
I want to embed a PDF file from a SharePoint site into my website. I have a link like https://etechua.sharepoint.com/sites/edocsrc/_layouts/15/embed.aspx?UniqueId=c385aa46-5a4a-4113-bc1b-e7d5768bab2d. Is it possible to set a default zoom level?
Currently, if we don’t specify it, the zoom level is set to fit page. I need it to be fit width.
I want to embed a PDF file from a SharePoint site into my website. I have a link like https://etechua.sharepoint.com/sites/edocsrc/_layouts/15/embed.aspx?UniqueId=c385aa46-5a4a-4113-bc1b-e7d5768bab2d. Is it possible to set a default zoom level?Currently, if we don’t specify it, the zoom level is set to fit page. I need it to be fit width. Read More
Condition Formula
Hello..
Pls. help me to apply formula if i want to get a profit Value of Customer X in region 5 for the month of May. how to get that this by using formula.
Hello.. Pls. help me to apply formula if i want to get a profit Value of Customer X in region 5 for the month of May. how to get that this by using formula. Read More
A feature request in edge
It would be really helpful if the edge app on startup shows the list of all edge profiles segregating them by personal and work, like the chrome’s startup screen.
It would be really helpful if the edge app on startup shows the list of all edge profiles segregating them by personal and work, like the chrome’s startup screen. Read More
OneDrive for MacOS – can’t search files in Spotlight
Hi
When using OneDrive on MacOS I can’t search my OneDrive files in Spotlight, making file access more cumbersome. I tried to edit the Spotlight search settings, but I don’t see my OneDrive folder there.
I checekd the SpotLight settings under preferences – and the “Folders” and “Documents” options are both set. Is this a OneDrive Limitation ?
Environment: MacBook Pro (Intel), Ventura 13.6.6
HiWhen using OneDrive on MacOS I can’t search my OneDrive files in Spotlight, making file access more cumbersome. I tried to edit the Spotlight search settings, but I don’t see my OneDrive folder there.I checekd the SpotLight settings under preferences – and the “Folders” and “Documents” options are both set. Is this a OneDrive Limitation ? Environment: MacBook Pro (Intel), Ventura 13.6.6 Read More
Insert the number of rows from a word table in the title
I have a Table and want to display in the Titel-row the number of colums the table has. How can I do this? please step by step advise since I am 68!
Example:
Title Column: This Table contains xx Entries
Row 1
Row 2
…
Row x
I have a Table and want to display in the Titel-row the number of colums the table has. How can I do this? please step by step advise since I am 68!Example: Title Column: This Table contains xx EntriesRow 1Row 2…Row x Read More
Excel Formula help needed
Hi, sorry a real beginner here trying to be better!! I want to add certain column’s together but the formula adds the last column twice and I don’t know why.
I am using this formula =SUM(D11:D14:D19) D19 has been calculated twice, can anyone advise please?
Hi, sorry a real beginner here trying to be better!! I want to add certain column’s together but the formula adds the last column twice and I don’t know why. I am using this formula =SUM(D11:D14:D19) D19 has been calculated twice, can anyone advise please? Read More
Missing teams recordings
Hello every body
when I finished my lecture I noticed that it was saved in recording file but unfortunately there were no other recordings from the previous sessions I made;
I checked in one drive and I found the same thing only the last lecture was there.
thanx for your respond.
Hello every bodywhen I finished my lecture I noticed that it was saved in recording file but unfortunately there were no other recordings from the previous sessions I made;I checked in one drive and I found the same thing only the last lecture was there. thanx for your respond. Read More
To Do Crashing on iPhone
Hi,
I have been using To Do on my iphone for few years and just recently started crashing and becoming annoying.
I tried many things such as deleting the app and reinstalling it, restarting my iphone, etc. but with no luck. I have been doing that for at least 3 weeks.
I am using the latest To Do version and iOS 17.5
Any help or Microsoft contact for To Do?
Thanks
Hi,I have been using To Do on my iphone for few years and just recently started crashing and becoming annoying. I tried many things such as deleting the app and reinstalling it, restarting my iphone, etc. but with no luck. I have been doing that for at least 3 weeks. I am using the latest To Do version and iOS 17.5 Any help or Microsoft contact for To Do?Thanks Read More
Renumber specific footnote
Hello
I would like my footnote numbering to skip numbers 71-75 and go from 70 to 76.
Footnote 76 is not in a different chapter; Actually my document is consisted of extracts of a single chapter text (hence the omission of several footnotes) but I still want the original footnote numbering kept.
Thanks
Hello I would like my footnote numbering to skip numbers 71-75 and go from 70 to 76. Footnote 76 is not in a different chapter; Actually my document is consisted of extracts of a single chapter text (hence the omission of several footnotes) but I still want the original footnote numbering kept. Thanks Read More
Excel Script Sharing Issues
Hi All,
I’ve created a sheet that uses a series of scripts for its basic functionality. The scripts have been working perfectly well for months (they need to get run multiple times per hour). When i originally shared the workbooks with people I created a sharing link and emailed it to them. This rapidly became unworkable because this didn’t easily include the ability to remove people’s access (and the people who need/don’t need access changes fairly constantly). So i removed everyones access, and re-shared person by person. Since I made this change issues have arisen around people within the organisation being able to run the scripts. I’ve gone so far as to turn the principle users into full owners of both the onedrive folder that contains the workbook as well as the folder that contains the various scripts.
The mad thing is when they open the workbook, they can run the script once, and then it stops working saying they need to contact the script owner as it has been unshared. Can anyone advise a good solution? Ideally I would like to embed the script entirely within the sheet so there are not sharing access issues (like a VBA macro used to be). Is there any way to do this?
Thanks for any advice.
Hi All, I’ve created a sheet that uses a series of scripts for its basic functionality. The scripts have been working perfectly well for months (they need to get run multiple times per hour). When i originally shared the workbooks with people I created a sharing link and emailed it to them. This rapidly became unworkable because this didn’t easily include the ability to remove people’s access (and the people who need/don’t need access changes fairly constantly). So i removed everyones access, and re-shared person by person. Since I made this change issues have arisen around people within the organisation being able to run the scripts. I’ve gone so far as to turn the principle users into full owners of both the onedrive folder that contains the workbook as well as the folder that contains the various scripts. The mad thing is when they open the workbook, they can run the script once, and then it stops working saying they need to contact the script owner as it has been unshared. Can anyone advise a good solution? Ideally I would like to embed the script entirely within the sheet so there are not sharing access issues (like a VBA macro used to be). Is there any way to do this? Thanks for any advice. Read More
MSIX Packaging Tool 1.2024.405.0 Release available
There is a new release of the MMPT available in the Microsoft store. It is version 1.2024.405.0. The release notes may be found at MSIX Packaging Tool release notes – MSIX | Microsoft Learn . Seems mostly about updates to what they can do with their version of the PSF.
Note: There is also a newer release build (1.2024.508.0) in the MMPT insider program mentioned on the page above. This would seem to be the support for the long awaited change to Azure Code Signing from the V2 to the new version that has been in preview mode itself for a long time. Perhaps that means we’ll see GA on that soon.
There is a new release of the MMPT available in the Microsoft store. It is version 1.2024.405.0. The release notes may be found at MSIX Packaging Tool release notes – MSIX | Microsoft Learn . Seems mostly about updates to what they can do with their version of the PSF.
Note: There is also a newer release build (1.2024.508.0) in the MMPT insider program mentioned on the page above. This would seem to be the support for the long awaited change to Azure Code Signing from the V2 to the new version that has been in preview mode itself for a long time. Perhaps that means we’ll see GA on that soon. Read More
matrix division
how to divide a full table by a fixed number?
how to divide a full table by a fixed number? Read More
Limitations of SharePoint Large Files Searching Content
Hi. D
o you know if there are any limitations or have you encountered issues when searching content in large files (200+ pages) using SharePoint Search Center or PnP Modern Search? (Sharepoint online)
Thanks.
Hi. Do you know if there are any limitations or have you encountered issues when searching content in large files (200+ pages) using SharePoint Search Center or PnP Modern Search? (Sharepoint online) Thanks. Read More
timestamp hotmail web version
may i know how to add timestamp for hotmail web version
thanks
may i know how to add timestamp for hotmail web version thanks Read More
How to create for desktop new Microsoft Excel in shortcut key
Just like we create a folder on the desktop using a shortcut key, we need to know how to create a folder on the Microsoft Excel office desktop using a shortcut key.
Just like we create a folder on the desktop using a shortcut key, we need to know how to create a folder on the Microsoft Excel office desktop using a shortcut key. Read More