excel
99 TopicsPython for Excel not showing in Formulas
I've followed the following steps: https://insider.microsoft365.com/en-us/join/windows chose insider level "Beta channel" and installed insider builds, waited for it to install and then opened excel and still python for excel can not be found and typing '=PY' in the formula bar gives an error. Any idea where is that coming from ? P.S when I search for python in the search bar I get "insert python" option but nothing happens when I click on it Thanks47KViews15likes42CommentsExcel on Android - numeric keypad
Most of my data entry in Excel is numeric, and I really like to choose the dedicated keyboard for number entry. There are three minor issues: Sometimes when I go back to Excel after a while it has defaulted back my standard keyboard (I used Gboard). Minor nuisance, because I have to reselect. In any case, an option to automatically select this keyboard when a cell is formatted as one of the number type would be useful (and the opposite for text) The keyboard should use the system defaults for keyboard sound and vibration. All pretty minor, but I feel they get between me and one of the most useful pieces of Android software.25KViews0likes19CommentsDataSource Error Access To The Path is Denied / PowerQuery Mac
I am trying to read a datasource (CSV) into Power Query. I keep getting DataSource error saying that it cannot read the file. This happens whether I try using "Get Data" or just editing an existing query so that it points to a different source. An exception occurred: [DataSource.Error] Access to the path '/my/path/to/the/file.csv' is denied. (Session ID: 6cc4c6b5-96d6-4d58-b68a-f20fcab1aa8f) Sometimes, If I make a copy of the file, then I can import that copy. But if I change the name back to what I want it to be named, then it can't connect. It's the same file, just with a different name. Sometimes when I go to Get Data, all the potential choices (ie.. all the CSV files) are grayed out. But if I rename one of the files then that one will (sometimes) not be greyed out and I can select it. But if I change it back to the name I want, then it grays out again. Very frustrating as a simple duplication task (ie. duplicating a query and then adding a different source) has become very hard indeed. Any ideas why this might be happening?18KViews3likes19CommentsCannot update to version 2309 after joined insider program [Target for Python in Excel]
Hi Community I am using a Microsoft 365 enterprise license and i want to access the "python in excel" function. I've join the office 365 insider program and signed up for Beta Channel. However, i wasn't able to update to latest version 2309. ( only reach version 2306 everytime i enter "update Now") how do i solve this kind of question? thanks in advance.15KViews1like3CommentsThe pandas code read_excel() does not work in Python/Excel, unlike in native Python.
I have an issue when I try to read a specific workbook in Excel using pandas read_excel() The following code was tested natively and it worked: import pandas as pd pth = "C:/Users/XXXX/Python 101/SUBPATH/" input = "inputworkbook.xlsx" wb = pth + input df1 = pd.read_excel(wb, sheet_name="Sheet1", skiprows=1) When I try to execute it from an excel workbook, I got this error message : FileNotFoundError: [Errno 2] No such file or directory: 'C:/Users/XXXX/Python 101/SUBPATH/inputworkbook.xlsx' Could you explain me why it doesn't work the same ? (Thanks)Solved12KViews1like10CommentsExcel: Making auto-sum adjust automatically to added lines
Hello, I have created a spreadsheet in which the columns are totaled at the bottom using auto sum. I add lines for new entries at the top in order to see the most recent entries easily. However the auto sum does not adjust to include the newly added lines. Is there a way to make it do so automatically? Thanks, KenSolved9.8KViews0likes4CommentsNew Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE
Hey Microsoft 365 Insiders, Great news for Excel enthusiasts! Excel now includes powerful translation functions, allowing you to translate and detect languages directly within your spreadsheets. The new TRANSLATE and DETECTLANGUAGE functions help break down language barriers, making your data more accessible and your workflow smoother. Discover how it works in our latest blog post by Gedion Alemayehu, Product Manager on the Excel team: New Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE NOTE: These are preview functions. Their signature and results may change substantially before being broadly released, based on your feedback. So, we do not recommend using these functions in important workbooks until they are generally available. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android6.2KViews2likes9CommentsWelcome to Excel Android beta program !
Hi there! As you might be aware, Google + is shutting down shortly for consumers. Therefore, we have decided to migrate to techcommunity.microsoft.com. We request you all to continue conversations here. To participate in beta community discussions, please do the below: Navigate to this link and press "Follow". Press "start new conversation" to create a new thread. In case you wish to respond to existing threads, please reply to them directly. You may follow the community link to get update about all 3 Word, Excel and PowerPoint We look forward to continuing interactions on TechCommunity, and request you all to follow Word space on Office Insider for Android community. Thanks for your support through this migration! Regards, Microsoft Office on Android Note: There will be no change in the way you will get beta builds, these will continue to happen as usual through https://play.google.com/store/apps/details?id=com.microsoft.office.excel To check if you are beta user, please open the link and look out for a banner which says "You are a beta tester for this app. Future updates will include beta versions."6KViews3likes6Comments