excel for web
2008 TopicsHow to filter to include blanks without selecting blanks.....
Good Morning All, I have a spreadsheet on Excel Online version that people fill in for requesting PPE and it has drop down boxes so they can select what they need. The people filling it in are not the most knowledgeable with computers never mind Excel just FYI for context. When the spreadsheet gets filtered eg to show only the requests for Bob, it shows the items for Bob and then the row underneath is row 532 which is outside my data and therefore the drop down boxes do not show so when someone comes to fill it in they can't select what they want to order and just end up free typing which defeats the object and means things can get missed. I want to be able to filter the spreadsheet in any column EG Bob so it shows the items for Bob and then the next row is the next 'available' row which in this example would be row 23 but also people are filling this in daily so row 23 is not set. Tomorrow it will have more data in and the next 'available' row could be row 30 so obviously tomorrow I would like to be able to filter to Bob, see all of Bobs items and then the next row showing is row 30. This is a test doc: https://1drv.ms/x/c/15153d41767146da/IQDVK5iPAiw-SoUyrf9ciYdwAb76zwpiF-IAtr6ISry1KwQ?e=v4vo3C Hope that makes sense and hopefully I am not asking for the impossible! Many Thanks,Solved77Views0likes2CommentsOnline Excel Version - Print Row Repeat/Print Titles
How do you set up the print row repeat or print titles option in the online version of Excel. I don't see these options available under Page Layout. Is there another location that this option is located or is this not available in the online version?12KViews2likes10CommentsASAP utilities in power automate cloud flow
I have one server machine that installed ASAP Utilities for Excel. I want to eliminate individual server logins and allow users to run only 5 specific ASAP Excel plugin functions automatically, just by dropping an Excel file into a common server folder, so the backend processes it and returns the result—saving time. Will Office 365 excel with power automate cloud flow help? Thanks for you answers for my clarifications.52Views0likes2CommentsChange 'Find' default from "Within: Sheet" to "Within: Workbook"
Title says it all, really. I am almost always searching for a name across different tabs, so it would be great for it to automatically search the whole workbook instead of having to change from sheet to workbook for every. single. search. Thanks!Solved63Views0likes1CommentSlicers not appearing for Excel Online
Hi all I downloaded an Excel spreadsheet from a course I am taking online. I created a pivot table and chart as instructed by the instructor. The next step is to add slicers. I am not seeing the "analyze" or the "slicer" button anywhere. At one point, I think I did see the "slicer" action but it was greyed out. Is this option even available on Excel online ? Where can I "add on" this feature. Thanks !31KViews1like9CommentsExcel App Builder: Should Excel Support Turning Workbooks into Standalone Low-Code Applications?
Excel has been much more than a spreadsheet application for a long time. In many organizations, Excel is already used as an informal low-code development platform. Advanced workbooks often contain not only data and formulas, but complete domain-specific logic: calculation models, planning tools, dashboards, input forms, reports, simulations, administrative workflows, and sometimes even small internal business applications. This is one of Excel’s greatest strengths. It allows domain experts, power users, analysts, engineers, teachers, consultants, and small businesses to build working tools without becoming full-time software developers. However, there is a structural limitation: the final product usually remains an Excel workbook. That creates several problems: the user needs a compatible Excel installation, macro security and Trust Center settings can block functionality, formulas and business logic are difficult to protect properly, distribution and updates are not as clean as with real applications, workbook-based tools often look less professional than standalone software, user interface, data, and logic are often mixed together in the same file. I believe Microsoft could turn this existing reality into a major strategic opportunity. Core proposal: Excel App Builder / Excel Runtime My suggestion is an official Excel App Builder or Excel Runtime. The idea would be to allow selected Excel workbooks to be packaged as protected standalone applications. Excel would continue to serve as the calculation, data, and automation engine in the background. The end user would not necessarily see the workbook itself. Instead, they would interact with a clean application interface: input forms, buttons, dashboards, charts, reports, controlled tables, and export options. Possible output formats could include: Windows apps, web apps, Teams apps, SharePoint apps, mobile-friendly internal tools, protected specialist applications. This would not replace Power Apps. In my view, it could complement Power Apps very well. Excel could remain the place where fast domain logic, calculations, prototypes, and models are created. Power Apps, Dataverse, Azure, and the wider Microsoft ecosystem could then support larger, scalable, enterprise-level workflows. In other words: Excel could become the natural entry point into Microsoft’s low-code ecosystem. Why this could matter strategically Excel already has an enormous “hidden developer base”: people who are not traditional programmers, but who build useful tools with formulas, tables, Power Query, Power Pivot, VBA, Office Scripts, and now AI assistance. This is a unique market position. Many of these users would not start with C#, JavaScript, Python, or a full application framework. But they already start with Excel. They already build the logic there. The missing step is a professional way to package, protect, distribute, and update those solutions. An official App Builder could: strengthen Excel’s long-term relevance, differentiate Excel from simpler spreadsheet competitors, create a stronger bridge between Excel and Power Platform, give power users a professional deployment path, create new commercial licensing opportunities, reduce the need for fragile VBA/UI workarounds, make Excel-based tools more secure and maintainable. Example use cases A small engineering office creates a technical calculation workbook and exports it as a protected customer tool. A school or university builds a grading, diagnostic, or planning tool with Excel logic but provides staff with a clean app interface. A small business turns an Excel-based quotation calculator into an internal sales app. A finance department packages a planning model as a controlled scenario tool for managers. A consultant builds specialized calculation tools and distributes them professionally without exposing the workbook structure. These are not exotic scenarios. Many people already build this kind of logic in Excel today. The difference would be that Microsoft could provide an official, safe, and professional deployment path. Supporting features that would make this stronger 1. Modern UI layer for Excel-based apps Excel-based applications would need a modern interface layer: forms, dialogs, navigation pages, buttons, card layouts, dashboards, responsive views, mobile-friendly layouts, role-based views, binding to cells, tables, named ranges, and data models. This would create a clearer separation between data, logic, and user interface. 2. Protected workbook logic A professional app export would require strong protection options: hidden formulas, protected named ranges, protected scripts or macro logic, defined input areas, digital signing, controlled editing, update mechanisms, possible licensing controls for commercial distribution. 3. Formula cells with controlled manual override One frequent Excel problem is that users overwrite formulas. A useful new cell mode could be: default formula + optional manual override The cell would keep the original formula internally but allow a controlled manual exception value. Excel could show whether the formula is active or manually overridden. This would remove many helper-column and VBA workarounds in planning, pricing, grading, budgeting, and technical models. 4. Native database layer inside Excel Excel is widely used as a database, even when that becomes fragile. A native database layer could support: primary keys, relationships between tables, required fields, validation rules, change history, duplicate detection, form views, simple queries, optional cloud synchronization. This should feel like a natural extension of Excel tables, not like a separate database product. 5. Multidimensional workbook models Many workbooks use separate sheets for months, locations, versions, departments, or scenarios. This often creates duplication and maintenance problems. Excel could support native dimensions for tables and models, for example: time period, location, scenario, version, department. Formulas, charts, dashboards, and PivotTables could become dimension-aware. This would be especially useful for financial planning, controlling, simulations, scientific models, and project planning. Why now? AI is changing how people build with Excel. Copilot and other AI tools make it easier for non-programmers to generate formulas, scripts, models, and structured workflows. That means more users will be able to build complex Excel-based solutions. But if AI helps users create more advanced workbooks, the next logical question is: How can these workbooks be safely packaged, shared, protected, and used as real tools? An Excel App Builder could be the answer. Possible first step This does not need to start as a massive platform. A realistic first version could be experimental: selected workbook ranges, simple input forms, protected formulas, dashboard view, Windows or web runtime, export as an internal app, optional Teams or SharePoint integration. It could even begin as an Excel Labs / Microsoft Garage style experiment to test demand and gather feedback from power users, developers, and organizations. Core question for the community Excel is already used as a hidden development platform. Should Microsoft make this official? Would an Excel App Builder / Excel Runtime be useful for your organization, clients, or internal tools? Which feature would matter most in a first version? protected workbook runtime, modern UI layer, formula override cells, native database layer, multidimensional models, Power Platform integration, commercial app distribution? I would be very interested to hear how other Excel users, developers, MVPs, and Microsoft product people see this idea. In short: Excel already allows millions of people to build domain-specific logic. Microsoft could turn that strength into an official, secure, and economically attractive low-code application platform.138Views0likes1CommentPivotTable Date Slicer Not Visible in Excel for the Web (Works in Desktop)
Hi everyone, I'm experiencing an issue with Excel for the web and was hoping to get some help. I have an Excel workbook that is linked to a 'Microsoft Forms' form. The form responses automatically populate the main sheet, and from that data I've created several PivotTables. In one of the PivotTables, I added a date slicer to filter the data. Everything was working fine at first, but recently the slicer is no longer visible in Excel for the web. However, when I open the same workbook in Excel Desktop, the slicer is visible and it works as expected. What I have tried so far: Recreating the PivotTable and adding a new slicer Creating a completely new PivotTable and slicer Checked if the slicer is hidden by adjusting the zoom Unfortunately, the issue persists in Excel for the web. Has anyone experienced this before and found a workaround? Any help would be appreciated. Thanks in advance.64Views0likes1Comment[DataFormat.Error] We received a malformed web response and credentials issue
Hi team :) Happy Friday !! There is an excel spreadsheet being connected with data sources and shared with users. Upon, hitting data refreshes it asks every user to edit credentials every time they hit data refresh or shows dataformat.error with malformed web response. There is no data format error though. Can anyone please assist here or know how to solve this issue ?? Thanks HappySolved155Views0likes1CommentExcel 365 Sheet Views are not working
I have 7 different Sheet views in a shared document, they were working fine until about a month ago. Since then I have tried everything, I deleted them, created them again and they don't work. When I create them they look fine but once my collaborators enter to work on the spreadsheet all the views start showing the default view. The sheet has the black border and the eye in the tab. How can I solve this25KViews2likes22Commentscombine multiple text into single line of text
Hi is there a way to combine all the cells into a single cell (of text) ignoring the duplicates/repeat values. i know concatenate but that function becomes very lengthy as ill have to define every cell into the function individually. is there any other function where i simply select the entire data (like an array) and it can do the required.Solved184Views0likes3Comments