Forum Widgets
Latest Discussions
Office Scripts
i have a business microsoft office account and am signed in with it. when i try running a script in excel i keep getting the error saying it requires a work or school account. my microsoft account says the following: your work or school account belongs to your home organisation. what do i need to do to get scripts working.
Export mixed text and tabular Excel to PDF
I have a sheet that I need to export from Excel to PDF. The sheet contains text and tabular data. Ideally, I'd like large bold text to export as heading tags, text as paragraph tags, and the tabular data as a table. Currently, any group of cells containing data that are surrounded with blank cells export as a table, even if they don't contain what a human would consider tabular data. I haven't selected the tabular data and chosen Import > Table. I'm not sure if that would help or not. How can I export mixed text and tabular data from Excel and have it be tagged as desired in the resulting PDF?Why are documents now displaying tiny cells and none of my cell text is visible.
Opened this application today to find this. The view is damaged or corrupted so that there are hundreds or thousands of cells visible in the viewport at 100% view scale. Zooming in does nothing to improve this. Zooming out to 10% then appears to show some of the text very small in the top left of the viewport, until zoomed in again at which point the text disappears once more. What is visible is very clear in the screenshots attached to this post. We have attempted an online repair of microsoft 365. this has done nothing. All existing documents persist in showing this. All new documents persist in showing this. We do not know what windows updates have been done. Nothing has been done by us. We do not know if any changes to drivers has occurred. Nothing has been done by us. We are looking for advice or knowledge from any user/s who have seen this specific issue before.
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?
