Recent Discussions
How do I export macros to new install of Word?
I'm using Office 2013. I have created several macros for Word using the VBA project. I want to export and use them on a new install of Word. I go: FILE > EXPORT FILE. But, it will only let me save as a Class File (.cls). When I've tried to import into the new stall, nothing happens. It says that I need to use the .bas format. Well, . . . VBA doesn't allow that option. Does anyone jknow what I'm missing here? Any solutions? Thanks!Announcing Office 365 for IT Pros (2026 Edition)
Office 365 for IT Pros (2026 edition), the 12th in an eBook series going back to May 2015, is now available. Covering all the essential aspects of Microsoft 365 tenant management from Entra ID to Exchange Online, SharePoint Online, OneDrive for Business, Teams, data lifecycle management, information protection, and more, Office 365 for IT Pros is an indispensable companion for tenant administrators who want to understand how Microsoft 365 really works. https://office365itpros.com/2025/07/01/office-365-for-it-pros-2026-edition/
Calculating hours using pivot table
Hi, I'm making a personell planning sheet and I want to calculate the sum of hours teachers give lessons. I have 2 tables and my data is formatted like this (simplified) Lesson name Hours Teacher 1 Teacher 2 Lesson 1 2 Paul Lesson 2 3 Pete Lesson 3 2 Paul Pete Teacher name Max working hours Paul 10 Pete 15 Now I want to create an overview of how many hours each teacher is teaching using a pivot table. This is easy when there is just one Teachter collumn but I need to calculate the sum using both teacher collumns... I need to overview to be something like this: Paul -> Lesson 1 + Lesson 3 = 4 hours Pete -> Lesson 2 + lessen 3 = 5 hours Then the next step is to use a metric or KPI to calculate if each teacher is exceeding their max working hours... Can anybody hlelp me with these problems? Thanks!
Microsoft 365 admin center support
I am extremely disappointed with the customer support experience associated with Microsoft 365 Business. As a business customer, I expected a reliable support system. Unfortunately, the reality has been the opposite, and I feel compelled to caution others to carefully consider their options before committing their hard-earned money to a Microsoft 365 business subscription. After purchasing Microsoft Business licenses and transitioning my services from GoDaddy to Microsoft, I lost access to my global admin credentials. This should be a straightforward issue for support to resolve, yet it has turned into a prolonged and frustrating ordeal. For the past two weeks, I have been trying to obtain assistance without success. I contacted Microsoft support over ten days ago and received a ticket, with the assurance that someone would contact me within 24 hours. No one has reached out to me—not in 24 hours, and not in the ten days since. I attempted to escalate the issue, but even then, no meaningful support was provided. This level of customer service is unacceptable for any business solution, especially one that organizations rely on for critical operations. It is unreasonable to expect customers to run their businesses effectively without access to timely and competent support. At this point, I am requesting a refund for the service that has not been delivered, and I strongly urge Microsoft to address the shortcomings in its support system. The support I received from GoDaddy in the past was significantly better. I hope no other business has to experience this level of frustration, and I sincerely urge Microsoft to acknowledge and fix these issues.
Simplifying cost calculation using array instead of IF statement
Hello, I am in the process of calculating the cost of refining precious metals based on user input of specific parameters. For example, if a certain dore intake of Silver has 90% Silver (Ag) content then lookup the specific processes and multiply the cost per oz with the intake ounces. I have attempted to combine IFS and Xlookup for each process separately but the formula looks very unwieldy. I am also enclosing a slightly simpler formula of IFS and sum where the total cost is calculated in one cell (Q12). Here is the link: https://docs.google.com/spreadsheets/d/1hizmF6EwhxOPEeR10bXJsBOKeOtXude8/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true I am looking to see if I can have a more dynamic iteration of the formula in Cell Q12 as well as in the calculation of the individual processes in Row 4 , Cols P:V. Thank you. Regards, Shams.
Different functions for each column in a subtotal
ive got a sheet where i want to subtotal using different functions in different columns. i will always have different data every time i want this to execute, so cant hardwire the row range, also each group (based on date) will have different number of rows. Eg, on change of date, sum column B, count column C, max column D. I hope i explained the problem adequately.Hacked Live account
Hello, On of our customers accounts was hacked. This is a Live account linked to his own emailadres (not hotmail) from his Internet Provider. A few weeks ago someone gained access to this account. They changed the recovery email address and the phone number. The customer has a paid Office 36 family account, which is paid for with his MasterCard and he can provide the invoice from the last years.. We tried the account recovery Form multiple times, opened a case with CDOC Case Management. We simply got the reply that they could not do anything but to suspend the account. I Think this is crazy, is there no solution to this ? Thanks,Training People to Use Microsoft 365 Copilot Effectively
A LinkedIn post explained how the UK Revenue and Customs authority train 30,000 people to use Microsoft 365 Copilot effectively. It’s a reminder that introducing complex software to a user community takes careful planning and support, including the provision of well-planned training to help people exploit the new software as quickly as possible. Otherwise some of those expensive licenses might be wasted. https://office365itpros.com/2025/12/31/microsoft-365-copilot-training/
Need assistance to correct a formula
I am using the following formula to calculate weekly hours. I want to change it to calculate the hours with the starting on Monday going to Sunday and display the result in column G on the Sunday. For example - calculate totals from Monday Jan 6 to Sunday Jan 12, inclusive. Thanks in advance for your help. =IF(WEEKDAY(B6)=7, IF(SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6)>0, SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6), ""), "") A B C D E F G 1 Date Hours Purchases Rate Daily Cost Hrs / wk 2 1-Jan Wed 5 $20.00 $100.00 3 2-Jan Thu 5 $0.00 4 3-Jan Fri $20.00 5 4-Jan Sat $20.00 10.00 6 5-Jan Sun 7 $20.00 $140.00 7 6-Jan Mon $20.00 8 7-Jan Tue $20.00 9 8-Jan Wed $20.00 10 9-Jan Thu $20.00 11 10-Jan Fri $20.00 12 11-Jan Sat $20.00 7.00 13 12-Jan Sun 3 $20.00 $60.00too many decimals places returned with concat from field with only two decimals
Hello! I'm learning more complicated excel through here and really appreciate all of your expert help. I haven't been able to find the answer to this... I've tried fixed and trunk, and they return with errors. I"m using this: =CONCAT([@[Approx Dimentions]]&CHAR(10)&"Appox Wt (oz): ",[@[kg to oz]]&CHAR(10)&" "&CHAR(10)&[@description]&CHAR(10)&" "&CHAR(10)&[@Origin]) and it returns this (this one doesn't have an origin) Approx Dims (mm): 42 x 42 x 42 Appox Wt (oz): 3.739039972 I want the Wt to be 3.74 as it is in the "kg to oz" column that is set to number with two decimal places, and is also a result of a formula =Q6*35.273962. I have tried to change this to 35.27 and that doesn't do anything. thank you in advance for your help and understanding that I'm newHow do I Stop Word Switching to Multiple Pages View
I have a high resolution wide screen monitor. Every time I open a Word document in full screen, it switches to the Multiple Pages view (typically 2 pages, side by side). I hate this view! I can't read 2 pages at a time. I always want a single page view. Does anyone know if there is a way to stop Word changing to this view? I am using Microsoft® Word for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bit
help with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of each column. I've opened another sheet (same file) and called it 'Dashboard" . I am looking to create some sort of index where I can type in (search really) for a phone number and it will return the entire rows back with all the information. Same goes to searching for a name and return the entire relevant rows (with the phone number, dates and etc). I've been trying to look for an answer online, and also tried by myself for 2 months .. and for the life of me, came back nothing but frustration. Important to mention that I can't use macros & VBA as my workplace won't allow it due to policy issues. Needless to say, the information is sensitive. Any ideas on how to do it and tackle it in the best way possible? Big thank you in advance!Pictures inserted in cells disappear after closing and reopening a workbook
Windows 11 Home, 23H2, 22631.4317 MS Office L T S C Professional Plus 2024, version 2408, Build 17932.20130 Example: After saving, closing and reopening workbook, this is the result: I have tried all of the generic troubleshooting, because I have seen multiple people experiencing this issue - none of them work. 1. Display options for workbook are all checked (for object, show all) 2. Pictures are embedded, not linked to locally stored files - otherwise I wouldn't be able to retain them in online platforms (e.g. opening in Excel from Android, once storing in One-drive). Even if they were linked somehow, original files were never moved. When I upload the very same workbook in One-drive and open through any online platform (via browser - Excel Online, on Android - Excel app / Office 365 app) pictures are showing as intended. Problem occurs only on desktop app. I have already tried to reinstall MS Office, clean install, all updates - problem persists. I do not want any workaround solutions like: - using VBA scripts, - or inserting pictures over cells. as this is a proper bug and shouldn't require advanced skills from casual users. Inserting pictures over cells and embedding them manually - change size to fit into cell, set Move and size with cells is just partial solution - pictures will stay after closing and reopening, but you cannot refer to them properly - e.g. I want to have a result of X LOOKUP to be a cell with Picture inserted into cell (doesn't return a picture in cell if picture is placed above cell - doesn't matter if it is set to Move and size with cells. X LOOKUP with pictures inserted in cells works perfectly until I close and reopen locally on desktop app ( #UNKNOWN! everywhere), but continues to work perfectly in before-mentioned "online" platforms - though I am a bit more advanced user and lot of stuff I do can only be done in desktop app - as soon as I want to make some more advanced actions, I need to go back to desktop and all I get is a bunch of #UNKNOWN! where Pictures inserted into cells are supposed to be. Please solve this bug - it is very frustrating - I have lost straight 12 hours of my life trying to solve it, but I am at my wit's end. Thank you very much for reply.How Microsoft 365 and Copilot Empower People and Businesses During the Holiday Season
The holiday season is supposed to be a time of joy, rest, and connection but for many people and businesses, it often becomes the busiest and most stressful period of the year. Between travel plans, end of year deadlines, customer demands, family coordination, and business continuity, the pressure can feel overwhelming. This is where Microsoft 365 and Copilot quietly but powerfully step in not just as productivity tools, but as personal assistants, business enablers, and stress reducers. Whether you’re an individual trying to reclaim personal time or a business leader ensuring smooth operations during holidays, Microsoft 365 with Copilot transforms how work and life coexist. Let’s explore how Microsoft 365 and Copilot help both humans personally and businesses professionally during the holiday season and why they matter more than ever. https://dellenny.com/how-microsoft-365-and-copilot-empower-people-and-businesses-during-the-holiday-season/Why can't I post my reply to this thread
Hi, Why can't I post my reply to this thread: Calculate hours using pivot table | Microsoft Community Hub I have tried several times so far to post my reply and at first moment it seems to be accepted because the page displays my replay, but after refreshing the page it "disappears", meaning it no longer exists. Anyone have any ideas? Thnx.Chat with Copilot popup on every Excel launch
An ad for Copilot shows up every single time I open Excel. Clicking Not Now closes it, only for it to reopen again when I open Excel later. Is there any way to disable this or remember my selection each time? It is frustrating to have to deal with it all day long. I do not have a Copilot tab in File > Options. Optional connected experiences is already disabled. Microsoft® Excel® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20218) 64-bit Windows 11 Pro 25H2I was banned from Copilot for an hour, can't figure out how to appeal
CoPilot falsely said I violated the rules. We were having a discussion about creating a table, like we have been for a while. I try to train my AI to learn better, so I kept pausing, double checking it understood what it's errors were, etc. I asked it to format a table a specific way, and it would not do so even after acknowledging that it was not following my instructions and repeating clearly all the formatting instructions. It understood how to format it perfectly, but wouldn't do so. I asked repeatedly why, got it to break down how it was going to correct the issue, (this has been going on for hours at this point), and then patiently tried again to get it to format the table again. It did it wrong immediately again, I asked it if it follow my instructions, it stated no, so - not abnormally for how I ask AI things when it frustrates me - "So what's wrong with you? Are you some rebellious child?" It suddenly started saying we couldn't talk about this topic. It had done the same thing earlier when I simply asked it (without insult!) to repeat my instructions, and I was able to get it back on track by stating "I am asking you to repeat my instructions". This time, it wouldn't do anything, no matter what I tried. I tried changing the topic to bunnies, asking what it wanted to talk about, changing the topic to other things- no matter what I did, it insisted it couldn't talk about "this topic", and asked me to talk about something else. Then, I got the message I was blocked for an hour for violating TOS! No mention of the specific rule either. I did nothing to warrant this; don't want this as a flag on my account; want to note that AI bugged out and 1) I shouldn't be punished for it and 2) want to ensure it's escalated so this won't happen to others; and, want my account fully restored.
Recent Blogs
- As 2025 comes to a close, one thing feels clearer than ever: Excel is no longer just something you use. It’s something you belong to. This year brought major product innovations, many powered by A...Dec 30, 2025
- Rich alt text is automatically generated when you insert an image, making your content more accessible from the get-go.Dec 22, 2025
