Recent Discussions
Table Merge from Web
Dear Experts, I need to export the below in a Single Table from below link :- https://portal.3gpp.org/desktopmodules/Specifications/SpecificationDetails.aspx?specificationId=3283 But when I use PQ, it gives me into different Tables, and I have to combine them Manually as below:- How shall , I merge them all into a Single Output? Thanks in Advance, Br, Anupam43Views0likes2CommentsWhen the Invoke-MgGraphRequest Cmdlet Needs Help to Fetch Responses
Sometimes it’s hard to get a response back from running a Graph API request with the Invoke-MgGraphRequest cmdlet. Graph Explorer helps. So does reading Microsoft’s documentation for the cmdlet. In the end, everything works out and we can discover some valuable information that comes back in a response header. In this case, the response header helps us discover if a purge job works. All of this might sound quirky, but it could make a difference to your PowerShell scripts. https://office365itpros.com/2025/06/12/invoke-mggraphrequest-responses/6Views1like0CommentsLinks to Spreadsheet on Android homepage gets greyed out
I have spreadsheets on OneDrive that I access via Excel Mobile. Since I used them every day, I created links to each of them on the android homepage. This has worked successfully for me for a very long time, but now the home page links being are being greyed out. When I open Excel to recreate the link, Excel does not list the file in the recent history, and I must go through the process of finding the file, opening and re-pinning it. I have tried opening the file from the laptop and making it favorite, but that doesn't help. Both Favorite and Pin fail. I have spent hours both alone and with Microsoft Tech Support trying to fix this. I tried everything they or I could think of, but no joy. They gave up, and suggested I ask the community, so I am asking.10Views0likes1CommentData info in separate date columns
I need to put data information in separate date columns in the same excel project. Let me give you an example. The project have 4 quarters lasting 3 months each. I need to put data information on each quarter column. People who use our service and we put information in quarterly report column. See this example below. Name. - age - gender - race Quarter 1 (Jan to March). Quarter 2 (April to June) Quarter 3 (July to Sept), Quarter. 4 (Oct to Dec) I need to separate the group of data into each quarter column so it won't repeat in other quarters using the formula on excel. I have used COUNTIF to calculate the group for each quarter column. I tried DATE but I got error, "#NAME?"23Views0likes1CommentHow can I customize the font in the Conditional Format
I can´t customize the Conditional Format. I can´t change the font type. Only appears a message: "This is a cloud source and will be downloaded when applied". I have tried all recomendations but I´m still having the same problem.28Views0likes1CommentI need help create a pdf with a button
Private Sub CREATE_GARY_TEAMS_PDF_Click() Dim FilePath As String ' Specify the output file path FilePath = ThisWorkbook.Path & "\GARY NFL TEAMS SCHEDULE.pdf" ' Select the sheets you want to export as ONE PDF Dim SheetArray As Variant SheetArray = Array("STEELERS FOR FRIENDS", "CHARGERS FOR FRIENDS", "RAIDERS FOR FRIENDS", "COWBOYS FOR FRIENDS", COWBOYS FOR FRIENDS" , COWBOYS FOR FRIENDS""EAGLES FOR FRIENDS", "BEARS FOR FRIENDS", "49ERS FOR FRIENDS", "49ERS FOR FRIENDS", "CARDINALS FOR FRIENDS", "RAMS FOR FRIENDS") ' Ensure sheets exist before proceeding Dim ws As Worksheet, i As Integer For i = LBound(SheetArray) To UBound(SheetArray) On Error Resume Next Set ws = ThisWorkbook.Sheets(SheetArray(i)) If ws Is Nothing Then MsgBox "Sheet '" & SheetArray(i) & "' not found!", vbExclamation, "Error" Exit Sub End If On Error GoTo 0 Next i ' Export sheets as a single PDF ThisWorkbook.Sheets(SheetArray).Select ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=FilePath, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=True ' Deselect sheets to prevent selection issues ThisWorkbook.Sheets(1).Select ' Adjust to a default sheet MsgBox "PDF saved at: " & FilePath, vbInformation, "Export Complete""" End Sub Steelers Chargers Raiders Cowboys x3 Eagles Bears 49ers X2 Cardinals Rams I have a worksheet called Button on that is enabled. I need help adding 2 more Cowboys. button. I tried putting a button worksheet in a PDF. file, I do not want that Thanks You31Views0likes2CommentsChart Tracking Multi-Daily Stock Positions of Multiple Stocks
I am trying to create a line chart (or another type of chart at someone's recommendation) to track the number of shares of stocks someone owns throughout the day over a four-month period. I am dealing with 13 individual stocks. For a number of these stocks the person made multiple trades a day, so the number of stocks he owned would go up and/or down multiple times on a single date. I have the data arranged in different sets of columns with the date, number of shares bought/sold, and then a running total of the shares owned after each transaction. For example: 12/01/22 | +100 | 100 12/05/22 | +500 | 600 12/05/22 | -300 | 300 12/05/22 | +700 | 1000 I tried adding the stocks one-by-one into a line chart but after adding the third stock the text of the horizontal axis, which would be the dates of each transaction, gets messed up and moves to the far left of the chart. If anyone has an idea on how to present this data in a chart, I would greatly appreciate your help/advice.23Views0likes1Commentexcel changing input values
need help anybody i have worksheet for jobs with varying job numbers but need to sum up the man hours spent on a job like the one shown below. the job numbers in all rows are changing during input and i need to tally all the hours spent in a specific job/s. i called it job manhour, accumulated manhr spent on a job. can somebody give me idea on how to do it best pls....98Views0likes5Comments"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THIS660Views0likes15CommentsHow to count text from a multi-line cell
Hi, I have an extract from a system that when opened in Excel looks like this in one multi-line cell: text text text text text Not all of the points 1-5 will contain text after them e.g. it could also look like this: 1. text 2. 3. 4. 5. On the sheet there are hundreds of multi-line cells that each contain the points 1-5 and I need a way to count how many of the 1-5 points for each cell have text after them. Does anyone know of a way to do this please? Many thanks for your help.Solved53Views0likes1CommentForm Combo Box Doesn’t Store Selected Value (Foreign Key Issue)
Hi all, I'm building a data entry form for the Peserta_Workshop table in Microsoft Access. This table includes a field called ID_Unit_Kerja, which is a foreign key referencing the Unit_Kerja table. In the form, I'm using a Combo Box to select a unit from Unit_Kerja, and I've set the Row Source to SELECT ID_Unit_Kerja, Nama_Unit_Kerja FROM Unit_Kerja. The Control Source is already set to ID_Unit_Kerja. However, when I select a unit from the combo box, the value does not get saved to the Peserta_Workshop table, and sometimes an SQL or NULL error appears. I’ve set Bound Column to 1 and Column Widths to 0cm;5cm. What could be the issue? Appreciate your help!44Views0likes2CommentsCan you use AND / OR in an INDEX MATCH
Hi I have am array formula that looks like this: =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2),0),1) which works. I want to add in an OR function for the name in column A. I will add this name in Column T. In other words the match is correct if column A or T match A2 and COL B=B2 and COL C=C2 also match the criteria I tried using the + to add T criteria but gave me a 0 =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2)+('Rebate report'!A:A=T2),0),1) Thanks for the help!137KViews0likes62CommentsHow to create a shared company calendar for time off and holidays?
I'M LOST I have spent DAYS trying to figure out some way to provide a shared company calendar with Holidays, PTO Schedules, On-Call Schedules, etc. We just want one place to see what's going on this week, who's available, and do we have a day off this week. BASIC information. After spending more than 3 days on this, I feel more lost than I did when I started. I could create a SharePoint Calendar. This calendar doesn't sync with Outlook for Mac or Apple Calendars and, most importantly, reoccurring events don't show up on a SharePoint Events web part. I could manually create reoccurring events but I rather not. Regardless, the functionality is incredibly limited. I could create a new M365 user. This would let me see these calendar in Apple Calendars and give myself or another admin access to update events. But this calendar can't be integrated in SharePoint or Teams so it's basically invisible. I could create a Channel Calendar in Teams but that's certainly not appropriate. I could create a new Group with a Calendar. Although, we already have a org-Wide Team and it doesn't actually do anything - can't email orgteam@company.com and it doesn't come with an Outlook calendar. I don't think I should have to add someone to a group for them to see a calendar I want public to the entire company. This might be the best compromise but that's besides the point. The POINT is, WHY in the world isn't this a built-in feature that's turned on the moment a company creates a M365 tenant? WHY do I need to spend days figuring out that all the archaic tutorials from 2017 don't even work in 2021? WHY can't MICROSOFT make calendars easy? I mean, I'd settle for difficult - it's better than impossible. And, not for nothing, I look like a complete idiot (I very well may be!) when my boss asks me to do something that should take 2 minutes and I have absolutely nothing to show 3 days later. Q: What is your business doing to let you know you have Memorial day off? How are you able to see if someone has the week off for vacation? Are you using a M365 product or something else?76KViews8likes26CommentsChecking multiple cells, skipping if blank and returning the value of the cell once it is found
I have tried all sorts of fomula's and the current version that I have is =IF(LEN(VLOOKUP(A2, inventory!A:E, 3, FALSE))=0,VLOOKUP(A2, inventory!A:E, 3, FALSE), VLOOKUP(A2, inventory!A:E, 4, FALSE)) What I am trying to do, is I have 2 worksheets in a workbook: list and inventory Worksheet 1: List Food Healthy Desserts Unhealthy Desserts Apple Chocolate =IF(LEN(VLOOKUP(A3, inventory!A:E, 3, FALSE))=0,VLOOKUP(A3, inventory!A:E, 4, FALSE), VLOOKUP(A3, inventory!A:E, 5, FALSE)) Grapes Cola In Worksheet 2: Inventory Food Mains Sides Healthy Desserts Unhealthy Desserts Apple Apple Chips Apple Pie Banana Banana Pancakes Chocolate Chocolate Cake Carrot Carrot Sticks with Dip Carrot Cake So, in this example, what I trying to do is for Chocolate, I want it to check the blanks, and if the cell is blank move to the next cell; however, once it finds a value in the specified Chocolate row, I want it to return that value in List cell on the other table... So in the Unhealthy Desserts option on the Lists Workbook of the Chocolate Row, I want Chocolate Cake to be populated as the value... right now I am getting #N/A. Please note the example is a sample of the sort of workbook I am using and VLOOKUP works great comparing the 2 sheets if I only have a single row to check (e.g. like Mains, but not if I have more than one column I need to check, like Desserts)Solved29KViews0likes13CommentsOrganisation Linked Data Type not working
I have a feature table published on Power BI Service that was previously accessible in Excel via the linked data type. However, for the past month, this connection has stopped working, and I'm unable to fetch data from the table. It appears the issue is related to authentication. Even the promoted dataset cannot be found or accessed anymore. This functionality was working fine earlier. I suspect this is due to a change in the authentication or security layer, because when I try to connect to a Power BI dataset in Excel using the "From Organization" option for a PivotTable, I am prompted to authenticate with Azure Active Directory every time. This suggests that persistent authentication is no longer being maintained. I believe this same issue is affecting the linked data type feature in Excel. Could you please clarify Has there been a recent change in the authentication model? Is there a workaround or fix to restore access to the linked data types from Power BI in Excel? Is the linked data type feature being deprecated? II tested on both current channel and beta channel If it's still working on your tenant, please do let me know or if its broken on your side as well , please update so that I can progress the issue accordingly. Thanks95Views0likes6CommentsReview tracked changes with new cards in Word
Hi, Office Insiders! Kimberley Chua from the Word team is here to let you know that we’re now bringing improvements to Word for Windows and Word for Mac: new Track Changes cards! New Track Changes cards Collecting and acting on feedback about your document is a critical factor in creating great content, and the Track Changes feature in Word is an essential part of that process. Now we’ve added new Track Changes cards, which make it easier to review a change before you accept or reject it. How it works Ready to give the new Track Changes cards a try? 1. When working in any Word document that contains tracked changes and shows all revisions inline, click on a tracked change in the text. 2. Review the suggested change in the card that pops up. Read the rest in the blog post! Cheers, Evann Office Insider Community Manager Become an Office Insider and gaining exclusive access to new features and help shape the future of Office. Join Now: Windows | Mac | iOS | Android8.5KViews3likes25Comments264 nested IF statements -- alternative?
Apologies if this is a duplicate entry. I can't seem to find what I thought I posted earlier. I'm looking for alternatives to using LOOKUP when there are numerous nested IF statements. Please see attachment with a screen shot of part of my data. I have 264 individual tables of data based on specific characteristics (age, education, etc.). Each table has 2 columns: score X, score Y. I'd like to be able to pull the t-score (right column) based on the scaled score (left column) depending on the characteristics I select. For example, if A1 is someone's age and B2 is someone's years of education, etc, I'd like to pull the data from the table that matches those characteristics. If I had only a handful of tables, I could use something like: =IF(AND(A1<34,B2<9 [etc. for other characteristics]),LOOKUP(D2:E21),IF(AND(A1<40,B2<9 [etc. for other characteristics]),LOOKUP(H2:I21), .... however, I know this will not work because I have 264 different tables/combinations of characteristics. Appreciate any recommendations. Thank you!Solved162Views0likes9CommentsHow to know if a tenant name is available or taken
If you need to know if a tenant name is available or taken in Office 365, I recommend to follow you one of the following approaches: First one is by using the following web page: http://o365.rocks/. There you will be able to do a quick check for the availability of a tenant name in Office 365. The other approach is just to use the PowerShell script you can find here: https://www.linkedin.com/pulse/how-check-office-365-tenant-name-availability-aaron-dinnage Screenshots and original post here: https://jcgonzalezmartin.wordpress.com/2016/11/21/office-365-how-to-know-if-a-tenant-name-is-available-or-taken/83KViews7likes8Comments
Events
Recent Blogs
- Join us as we celebrate Pride, specifically the Pride we have for each other. Pride has always been a celebration of identity—visibility, self-expression, and the joy of being unapologetically yourse...Jun 05, 2025382Views0likes0Comments
- We are excited to announce that Microsoft 365 and the Microsoft 365 Advanced Data Residency add-on (ADR) are now available for commercial customers in MalaysiaJun 04, 2025407Views0likes0Comments