Recent Discussions
Excel 365 (version 2307&higher) crashes when refreshing pivot tables (more pivot tables at once)
Dear all, I am currently experiencing the following problem in Excel 365 version 2308 with pivot tables (on MSAS connections): Excel always crashes if I'm refreshing data for all connections for more pivot tables at once - especially when I have 2 pivot tables with the same connection on 1 sheet . This happens always :o(. Excel will NOT crash under any of the following situation, 1. I have to change some filter on each! pivot table (without refreshing); 2. After that I can refresh pivot tables. I must do the same after opening Excel file next time. I have tested it on multiple machines and the symptoms are consistent over all the machines with Excel 365 version 2307&higher. Stable workarround is NEXT: 1. I must have PC with lower version of Excel (I have old notebook with Excel 365 version 1808 at home). 2. Change connections to local PC with local MSAS (I have no connection to original MSAS from local PC). 3. Open file & refresh all connections. 4. Save & copy to PC with Excel 365 version 2308 5. Open file & change connections to original MSAS 6. After that refresh works fine. Now this file will work in Excel 365 version 2308. Can you kindly advise if anything can be done to this issue? - I have many Excel files on version 2308. Thank you in advance.11KViews0likes6CommentsOffice 365 no internet error
Outlook just stopped working yesterday. I have been using 356 for a couple of years now. One drive and Outlook both say I don't have internet access. Obviously I do. I can use one drive and outlook via a web browser, but not the desktop apps. I have tried most of the suggested fixes and nothing has worked. Anyone else having issues?23Views0likes2Comments- 36Views0likes4Comments
Max of Fiscal Year in pivot table Value section is not working
There are three data columns in the shared Excel file at the link below. Membership ID formatted as text Num (billing id) formatted as text FiscalYear formatted as numeric The pivot table values for the MAX of FiscalYear in the Value section are all 0. I expected to see the most recent fiscal year for each unique membership id. The FiscalYear data column: has no blank cells has no text cells has no mixed numeric/text cell values The pivot table has been refreshed. Would you please explain why the most recent fiscal year for each membership id is zero? Once I understand what the issue is and resolution, I will expand the pivot table range to reference the entire column for each of the three columns instead of a ranged specified by specific row numbers. The link to the Excel file is: https://docs.google.com/spreadsheets/d/16B3JJ_Zn1848R4THgxYcz1piwju5Zlg7/edit?usp=sharing&ouid=111420556245583625384&rtpof=true&sd=true Thanks in advance for your help!Solved55Views0likes3CommentsCalculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.Solved63Views0likes4Comments- 11Views0likes0Comments
Errors in Event Viewer
Since updating to the latest beta version 15209.20000, the following errors appear in Event Viewer: Failed to parse element: VersionOverrides Id=d949f36b-4eb7-4269-8eae-db0a399b7ca2, DisplayName=Transcribe, Provider=Microsoft Office Services, StoreType=SdxRdx, StoreId=(null) P1: Apps for Office P2: 16.0.15209.20000 P3: 0x8004323E P4: New Document91KViews9likes45CommentsAllow form respondents to save and continue to fill the form later
My comment refers to this voting: https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/18447406-allow-form-respondents-to-save-and-continue-to-fil In our company we use sharepoint and MS 365 Business every day. MS Forms is very intuitive and esasy to handle, thats great! I made a long survey on sustainability topics to our members. Then I got feedback that in many cases more than one person in the adressed member companies have to work together according to their expertise... so they need the option to save the survey, send it to another colleague who can conitnue answering the question... Right now I have to look to alternative tools to fullfill this very important option. But I would prefer to continue my survey (where I already put more than one week of effort) in MS Forms. Is there already any timeline, when Mircrosoft will implement this function? Best regards from Germany Matthias104KViews18likes54CommentsWord fillable forms that are mobile device compatible
I can't find any recent info on how to make word fillable forms compatible for mobile devices (so they can be completed on mobile phone). I've set up forms, and they are restricted for fillable entry only. They send via email and work on PC, but on a mobile, if opened through mobile word app, you can select but not input anything. If this worked if would save so many issues for me, but I've no idea if or how it can be done. I have read some stuff on Infopath, but this is a little beyond me. Did try it but it would not import my word fillable template. Not really keen to redesign my many forms, if I don't need to and would rather reduce number of apps/add ons if possible. Any advice?2.3KViews1like2CommentsOutlook "Classic" issues
Without any changes being made to my system, I am suddenly getting the following error message when trying to send/receive mail. Task 'email address removed for privacy reasons: Folder:Inbox Check for new mail.' reported error (0x800CCC0E) : 'Outlook cannot download folder Inbox from the IMAP email server for account email address removed for privacy reasons. Error: Cannot connect to the server. If you continue to receive this message, contact your server administrator or Internet service provider (ISP).' I have followed all of the suggested solutions that I could find including editing the registry but nothing is working. Hope someone can help as thjis is a big problem for me.17Views0likes1CommentPython in Excel - Missing from desktop Excel but exist in web Excel
Good Morning! Yes, again this topic :-( When I join to a professional forum I also search for the topic I having a problem with. Found a lot of similar questions but I could not find a post with a solution. Maybe I was not enough attentive and patient but I did not. Well, we are a University in Hungary, and we have Microsoft 365 A1, A3 and A5 licenses. I attahced a screenshot which shows: in the desktop Excel I got #CALC! error msg when I type =PY and press TAB. But it works in Excel on the Web version. So the root of the problem cannot be the license, right? Of course I saw this article about "Python in Excel availability": https://support.microsoft.com/en-us/office/python-in-excel-availability-781383e6-86b9-4156-84fb-93e786f7cab0 Our licenses are based on user, not device so no, it cannot be that the computer is a device with shared license: My Excel version is on: So the version and the channel are also OK. (OK?) I am also a Global Adminisitrator in our tenant, so I could check if the Connected experiences and Optional connected experiences and all related possibilities are disabled or not: no, it is not disabled. On "Microsoft 365 Apps admin center" : https://config.office.com/ ... I did not find any policies which controls those options so in "Policies for all users" policy I modified all these settings from "Not configured" to "Configured" and "Enabled". In my Excel the Trust center related settings looks like this: Of course my Office package up to date, I ran the Update Office and Update License command from Excel. Did not help. I went also to https://admin.microsoft.com site if I can find any related setting, but did not. I also tried to Sign out and Sign back in Excel - did not help. Finally, as our computers are in Hybrid environment (so our users are logging in inti on-prem AD, and their properties are synchronised to Azure) I have cerated a Group Policy object (I am also a Domain Admin), which also allows connected and optional experiences for all domain users: I should not mention: did not help :-( I have checked if the GPO is applied or not by running GPRESULT /R, it applied, it is in the registry. But despite all the settings so far - nothing helped. The Python in Excel feature in desktop Excel do not want to work. But it does in web based Excel. I would be very happy to receive any ideas from anyone. Or if U say I should go to official Microsoft support, then I go. Have a nice day! Regards, Andras /sorry for the very detailed case description, but maybe easier and quicker if I "aswer" all usual questions in advance/139Views0likes6CommentsSelecting a specific year using the FILTER function
I am trying to use the filter function to get all the records from a table for a specific year. I have a table that has a date column The filter I am trying to use is =FILTER(Venues14,Venues14[Date=K5,"Is not found"). Cell K5 is a dropdown list that has 2026, 2027 and 2028 in it. I am trying to use the dropdown list to extract all the entries in the table using a date I select. It gives me all the dates instead of just the one.44Views0likes4CommentsMicrosoft Bookings - Availability not showing
Hi there, I have created a shared booking page in Microsoft Bookings and set up custom availability so that appointments are only available on specific days and times over a two-week period. I have also set General availability to “Not bookable,” as I only need certain time slots to appear. However, when I access the booking link, not all of the dates and times I configured are showing on the page. I have double-checked that the time zones are correct and that the availability settings on both the booking page and the staff profiles match exactly. Despite this, some days and times are still missing. Could you please help me resolve this issue? It is missing whole days (such as 19th March and 26th March), as well as times...)59Views0likes2CommentsWelcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team64KViews30likes92CommentsMAX of numeric data column in excel pivot table returns 0
There are three data columns in the shared excel file - a Membership ID column formatted as text, a billing number in column Num formatted as text, and a FiscalYear column formatted as numbers. As I want to see the most recent fiscal year in the pivot table for each unique membership id, I added MAX of FiscalYear in the pivot table Value section. In the FiscalYear data column: There are no text entries. There are no blank cells in the column in the pivot table range. The formatting in the Value Field Settings for MAX of Fiscal Year is numeric. I have refreshed the pivot table. Yet I am seeing a zero for each Membership ID rather that the most recent fiscal year. Would you please explain why the Max of FiscalYear is not working correctly, and once I understand how to correct the problem, will the correction also work when I expand the pivot table range to reference the entire FiscalYear column rather than the column cell values in the first 29 rows? There will be blanks in the unpopulated FiscalYear column cells as the remaining rows will be blank for all three data columns until more rows are added over time. Link to the Excel file on OneDrive https://docs.google.com/spreadsheets/d/16B3JJ_Zn1848R4THgxYcz1piwju5Zlg7/edit?usp=sharing&ouid=111420556245583625384&rtpof=true&sd=true Thanks in advance for your help?Solved63Views0likes3Comments
Events
in 19 hours
Learn more about the capabilities of Agent 365 in this live 'Ask Microsoft Anything' with product and engineering team experts! Get your questions answered about capabilities for agent observability,...
Wednesday, Mar 18, 2026, 09:00 AM PDTOnline
4likes
362Attendees
1Comment
Recent Blogs
- The matchups are finally set, and the annual question is back: how do you pick a bracket that’s fun and gives you a real shot at predicting the winner—whether you’re following the men’s tournament, t...Mar 17, 2026176Views1like0Comments
- Technology is evolving at a startling rate, and it’s no longer enough for an organization to maintain their security measures, they must evolve along with it. Don’t let your data, employees, or clien...Mar 12, 2026245Views0likes0Comments