excel
44313 TopicsTrying to transfer information from one excel sheet to another.
Hello, I'm new and just learning how to work excel, I was wondering how or what formula would I use to make it so that when I put information on one sheet it would transfer over to another excel sheet. For example, I would put the information on Sheet1, and it would transfer over to Sheet2 on a specific cell.2.6KViews0likes3CommentsExcel font rendering blurry when zoomed out (Windows 11, Microsoft 365)
Hello Community, I’m experiencing an issue with Excel (Microsoft 365) on my new Windows 11 ASUS touchscreen laptop. The text in Excel becomes noticeably blurry when zooming out, but looks fine when zoomed in. This problem does not occur in other applications (like browsers) and did not happen on my older Windows 10 laptop running the same version of Excel. What I’ve tried so far (with Microsoft Support): • Tested in Safe Mode → still blurry • Checked ClearType text and confirmed scaling at 100% • Verified “Optimize for best appearance” is already set • Installed Office updates and restarted device • Disabled all add-ins • Disabled hardware acceleration in Excel • Updated graphics drivers and adjusted GPU scheduling • Removed second monitor → no change • Compared display settings and Excel files between devices • Checked Excel Options for missing settings (e.g., Hardware Graphics Acceleration toggle not visible) • Remote session with support agent confirmed the issue persists Observations: • Only affects Excel (not other apps) • Text looks fine when zoomed in, but blurry when zoomed out • Blurriness persists even after updates, safe mode, and driver changes • Same Excel version works fine on Windows 10 • Touchscreen and scaling differences were considered but ruled out Has anyone else experienced this issue with Excel on Windows 11 (especially on ASUS touchscreen devices)? Is this a known rendering limitation, or are there any reliable workarounds/fixes to improve text clarity when zooming out? Thanks in advance for any insights! See the attached below for your reference: with blurry: without blurry issue:27Views0likes0CommentsPython in Excel - not in toolbar
I have MS Excel (Current Channel) via an M365 - Business Premium license I have Python in Excel; I know this because if I type '=py' in a cell and hit tab I get a python cell with the green [py] box. However, I do not get the Python group in the Formula toolbar... why?? This grouping is supposed to have the 'Insert Python', 'Initialization', and 'Reset' controls in a grouping named Python. Subsequently, I have had to create a custom grouping with the relevant python controls added manually... What is the cause of the python controls missing from the Formula toolbar?21Views0likes0CommentsResubmitted response overrides original response instead of making a new entry
Hi, I have a Microsoft Form that allows respondents to edit their submissions after submitting. Last week when someone resubmitted their response, it created a new entry in the Excel sheet which is what I prefer since it triggered a Power Automate flow. However, I ran it again this week and now it seems to override the original response in the Excel sheet. This does not trigger the flow, which is a big issue. Does anyone know why this might be happening/how to fix it? Thanks in advance!42Views0likes3CommentsExcel desktop application crashes when trying to share or copy link
For the last couple of weeks when I've attempted to share an Excel file from the desktop app (multiple different files) the application crashed and closes out. The file are all saved to my personal OneDrive. It only seems to affect the files from my SharePoint, and only when trying to share through the desktop app. I can open it on the web version and share. I tried sharing a file that was opened through a SharePoint site and it seemed to work.80Views1like2CommentsExcel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, Daniel93Views0likes3CommentsNew in Excel for the web: Power Query Refresh & Data Source Settings for authenticated data sources
We’ve reached yet another milestone in Excel for the web: Power Query Refresh is now generally available for queries sourcing data from selected authenticated data sources. As we released the ability to refresh Power Query data from anonymous data sources (link), it was only a matter of time until we added the ability to refresh Power Query data from authenticated data sources, which are the majority of data sources used, and require users to enter credentials. This milestone also enables us to release Import with Copilot to Excel for the Web (following Win32 and Mac), as it relies on Power Query for refreshing data. Getting started These new functionalities are available to all users on Excel for the Web. See this support article for more information on Power Query data sources in Excel versions. efresh a data source in Excel for the web using Power Query Refreshing Power Query queries You can now refresh the Power Query queries in your workbook that source data from a selection of authenticated data sources: Select the Data tab > then choose Refresh All Open the Queries Pane > then select Refresh When you refresh a query, if authentication is needed, you can select the relevant method – anonymous, user and password, or your organizational account. For example, to refresh organizational data, select the respective method: Your user will be automatically identified (you can also switch it, if needed), so you can easily click “Connect” to continue the refresh process. The list of supported connectors includes: SharePoint* files (Excel workbooks, TXT, CSV, XML, JSON, PDF) SharePoint* folders SharePoint Online List SharePoint List SQL Server Database OData Feed Web API IBM Db2 Database PostgreSQL Database Azure SQL Database Azure Synapse Analytics Azure HDInsight (HDFS) Azure Blob Azure Table Azure Data Lake Storage Gen 1 Azure Data Lake Storage Gen 2 Azure Data Explorer Dataflows Dataverse Microsoft Exchange Online Dynamics 365 (Online) Salesforce Objects Salesforce Reports *SharePoint/OneDrive for work or school The refresh happens behind the scenes so you can keep editing the workbook while refreshing. Note: There is a limit for 1000 data source credentials. For example, if you connect to the same data source with 2 different users, it counts as 2.. Managing queries using Data Source Settings You can now view and manage data source credentials for the Power Query queries in your workbook using Data Source Settings: Select the Data tab > then choose 'Data Source Settings’. Choose between ‘Current Workbook’ and ‘Global Permissions’ to view and manage data sources credentials in the current workbook or across all workbooks, respectively. To delete the credentials stored for a data source, click on the ‘Delete’ button. To edit the credentials stored for a data source, click on the ‘Edit credentials’ button. In addition, we’re introducing a new functionality in Data Source Settings – authenticating to a data source that exists in the workbook from within the dialog: Select the Data tab > then choose ‘Data Source Settings’. Navigate to ‘Current Workbook’. Click on the ‘Add credentials’ button: What’s next? Future plans include releasing the full Power Query Editor experience to Excel for the Web. Feedback We hope you like this new addition to Excel and we’d love to hear what you think about it! Let us know by using the Feedback button in the top right corner in Excel - add #PowerQuery in your feedback so that we can find it easily. Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter. Jonathan Kahati, Gal Zivoni ~ Excel Team3.7KViews10likes17Comments