Forum Widgets
Latest Discussions
Excel Copilot fails when local workbook filename contains #
Excel Copilot does not work with locally stored workbooks whose filename contains the '#' character. The same workbook works correctly after renaming the file to remove '#'. The same workbook also works when stored on OneDrive with '#' in the filename. The issue appears specific to local files and filename parsing. Specifically, when clicking on Copilot in Excel, Copilot says "This file type is not supported for editing with Copilot. Please save this file as a modern file format, such as ".xlsx", to be able to edit it with Copilot." Interestingly, Copilot works fine if the Excel file name contains, for example, % or &, the problem only occurs if the name contains #. We suspect this is a bug. In our workflows, we work a lot with files that have # in their names and we would be very happy if this was indeed a bug and if it was fixed. Tnx.
Welcome 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 Team
Which postal codes are available on cartogram chart
I want to show some data on the cartogram chart - thousands of records which belong to certain postal codes. Basically this works fine using the cartogram chart. I have a Country row, postal code row and a value row. The problem is that some postal codes are not known (Germany and Austria) but they are found in e.g. USA (even though I do use the country row). This makes the chart impossible to use because instead of Germany I see nearly the whole world. Land PLZ Wert Deutschland 80331 20 Deutschland 80333 20 Deutschland 80335 20 Deutschland 80336 20 Deutschland 80337 20 Deutschland 80339 20 Deutschland 80469 20 Deutschland 80538 20 Deutschland 80539 20 Deutschland 80634 20 Deutschland 80636 20 Deutschland 80637 20 Deutschland 80638 20 Deutschland 80639 20 Deutschland 80686 20 Deutschland 80687 20 Deutschland 80689 20 Deutschland 80796 20 Deutschland 80797 20 Deutschland 80798 20 Deutschland 80799 20 Deutschland 80801 20 Deutschland 80802 20 Deutschland 80803 20 Deutschland 80804 20 Deutschland 80805 20 Deutschland 80807 20 Deutschland 80809 20 Deutschland 80933 20 Deutschland 80935 20 Deutschland 80937 20 Deutschland 80939 20 Deutschland 80992 20 Deutschland 80993 20 Deutschland 80995 20 Deutschland 80997 20 Deutschland 80999 20 Deutschland 81241 2 Deutschland 81243 2 Deutschland 81245 2 The above data works nice - but change the postal code from e.g. 81243 to 81242... Any hint how to either remove not working postal codes or show just Germany/Austria on the cartogram chart?
If formula based on cell value
Not sure if an "IF" formula is the right one needed here, but this is what I am trying to do. In cell B9, I want text to display based on what is in cell I6. I have I6 set up as a list of one of the following AS, EA and PI (acronyms for Assemblies, Each and Per Install) I am trying to get the worksheet to do the following If I6 is blank, I want B9 to read "Select Unit" if I6 is AS, I want B9 to read "Assemblies" if I6 is EA, I want B9 to read "EACH" if I6 is PI, I want B9 to read "Installs" This is what I started with, but I cannot figure out how to include the rest of the conditions - =IF(I6="AS","Assemblies","Select Unit") Any help would be appreciated. Thanks,Currency Formatting adding additional periods to number
Hi, This has started happening on Excel and its baffling me so I thought I'd reach out to the community to see anyone can help. This is Excel v2606 (M365) with latest updates. Issue: I have a new work book and in a cell I simply add the number 20 I right click the cell with the 20 in it and select "Format Cells.." and change it to currency and this happens If I go back into "Format Cells" the selection has moved from Currency to Custom and it shows this: And clicking on Currency the format is shown as this: No matter what I do I can't get it to format correctly, if I change the format back to "General" it goes back to being 20. I've tried doing an online repair and that hasn't had any affect. Any help gratefully received. Robhow to ignore conditional formatting for a cell that is not empty but invisible (cell format ;;;)
hi, i need help with a conditional formatting of cells that are not empty but invisible (cell format to ;;; (invisible)). I have a calendar where the dates are invisible (outside of the month) but the cell formatting applies to it (cuz it is that date, i.e., public holiday). i have attached the screenshots and i hope someone can help me out. thank you so much. regards, angel
