Forum Widgets
Latest Discussions
Delete a print area label on a worksheet
Hi, I would like to delete the print area labels on a worksheet. I find that the labels I used are not descriptive enough. Excel names the first print area as Print_Area. The next area would be labeled Print_Area_1. I would like to delete all of the labels or perhaps selected labels so I can enter a label name such as Print_Area_1_SUN. Would appreciate your help with this. Joe
Using average
I keep a golf spread sheet that has all the points of each round. For handicapping purposes, we use the average of the last six scores. Since not every player plays each week, the six scores needed for the average will be different cells. I need a formula that will average the last 6 entries that have a score entered. Each week I will add another column and would like it to update the average of the last six rounds with a score.
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?
Adding measures in a data model at a summary level - how ?
I'm probably not going to describe this very well - but here goes 🙂 I am new to data modeling and am trying to convert old files / pivot tables to new table design/data model structures and at the same time develop some new reports for key stakeholders. The attached file has a table (I know its not optimal in terms of structure - but way better than it was). This table (called Hours_New) collects employee time daily. The time is regular, ot or unpaid. It is also chargeable or non-chargeable (as determined by the column in the table titled SC & CD Combo. There are productivity targets (50% for labourers, 75% for other trades). What I want to be able to do is report the productivity % at various levels (Foreman, Trade, Time Period etc etc etc). When I build pivot tables to try and do this I'm not able to get the results presented as I want them - I've taken a couple of stabs at it, but the results are way too busy & I want to be able to highlight when targets are being missed (on both upper and lower ends). I'm sure its not all that tough to do but I'm spinning my wheels - grrr. The attached file has multiple tabs and I've trimmed the dataset down - its actually close to 500,000 rows and removed most of the other pivot tables not related to what I'm trying to do - any help would be most appreciated !!
Excel .xlsm files showing “We found a problem with some content” after saving
Hi everyone, Good day. I’m currently experiencing an issue with Microsoft Excel involving macro-enabled files (.xlsm) that contain VBA code and are stored in Microsoft OneDrive. Scenario: I open an .xlsm file (with VBA), make edits or even just open and save it. When I reopen the same file, I get the error:“We found a problem with some content… Do you want us to try to recover as much as we can?” Additional details: This issue started happening on April 15, 2026. Files created in 2023 were working before, but now they are no longer working even if I did not make any changes. The issue now happens consistently even without modifying the file. What I’ve tried: Opening and repairing the file Saving as a new file Checking OneDrive sync Has anyone encountered this issue recently, especially with OneDrive syncing and .xlsm files? Any suggestions or fixes would be greatly appreciated. Thank you in advance for your help.
Spreadsheet Corrupts Upon Saving
Starting this week, a specific spreadsheet I've been using for years is now corrupting when I save it. First it'll prompt "We found a problem with some content. Do you want us to try to recover as much as we can?", and after clicking on Yes it'll come up with "Excel was able to open the file by repairing or removing the unreadable content. Removed Part: /xl/drawings/drawing1.xml part. (Drawing shape)". I restored the spreadsheet from backup (saved and working fine 5 days ago) and I'm able to open... until I save it. Once it's saved, it'll corrupt it with the prompts mentioned above. For a test, I even opened a 2024 and a 2020 template version of this spreadsheet and I get the same issue now. I suspect an update was pushed and now somehow is corrupting some of this spreadsheet's objects. Other spreadsheets seem to be ok, only this one is impacted; though I haven't opened all my spreadsheets to test yet. Thoughts?Slicers show (blank), but no blanks exist in the data model
My workbook's purpose is to function as a decision tool. Providers select services they offer using a series of slicers. Their responses filter a pivot table, which shows them which license they should apply for. Some services may be required (or not permitted) under certain licenses. Each slicer represents a service category/type, and slicer options are the specific criteria/specific services used to determine the best license. All options are mutually exclusive (i.e., none of them appear in multiple service categories). In the file, the 'status' variable indicates whether a specific service can be offered with a particular license. There are 4 statuses: Required: the provider must offer this service to qualify for X license (slicer option must be selected) Optional: the provider may offer this service but doesn't have to in order to qualify for X license (slicer option can be selected but doesn't have to be) Not applicable: the service is irrelevant to X license (selecting slicer option has no effect on recommended license) Cannot provide: the provider cannot offer this service to qualify for X license (slicer option cannot be selected) The main issue: In all slicers, (blank) shows as one of the options. There are no blanks in the reference tables. All "real" slicer options also line up with something in the license requirements table... so there aren't any mismatches in the data model that I've been able to find. This is affecting my workbook in two ways: I can't find a way to hide (blank) from the slicers, because I don't know where it's coming from. When (blank) is deselected from a slicer, the filtered pivot shows the number of criteria in each status column for the corresponding service category. Example: The population served service category has 2 valid answers (1 of which is optional and 1 of which is not allowed for License A). When (blank) is deselected from the population served slicer, the filtered table shows 1 in the optional column and 1 in the cannot provide column for License A. Other info: Allowing multiple selections is critical to the final product, so that will have to be done when the file is opened. I tried creating tables for service type, status, and service types/their corresponding options, just in case the data model didn't like the original. These tables are currently part of the data model, but they don't seem to make a difference either way. There are many combinations of services that could be offered. Some act as exclusion criteria for other licenses, so slicers shouldn't be connected to each other. Therefore, I've unchecked the 'hide items with no data' and 'visually indicate items with no data' slicer options. The final workbook will include more license types and additional functions. I removed several licenses to make the file shorter, but all service categories and options are present (since that's where the problem seems to be). I'm not sure how to attach the workbook, but has anyone had this issue before? Is there an issue in the data model somewhere? What am I missing? Any help would be much appreciated!
