Recent Discussions
Auto fill cells depending on another cells content
I'm OK with Excell, but by no means an expert. I'm creating a sheet that will calculate gas purge volumes, and I've got most of the cells sorted with calculations based on other cells, but one of them is giving me a headache. It's probably simple for those with experience. So... I have cell E2 which contains a drop down list (linked to another sheet) which gives options (which are meter sizes) E6, U6, G4, U16, etc. What I'm trying to do is get the column F2 to auto fill depending what is selected in E2. So, if someone selects meter size U6, cell F2 will auto populate with the number 0.0028, if they select meter size E6 then cell F2 will auto populate with the number 0.008, etc Sorry if the use of E6, U6 etc complicates things, those are the actual names of the meters. Any help is greatly appreciated.
New to Access
Hello! I am new to MS Access, and currently looking for some advice in working the program. In using Access, I am working with a team that has data in arts and crafts projects that fall under many different categories, which are being exported from Excel. I’ve attached an image of what this data looks like, but I’ve also explained it below. For instance, the data might be sorted into something like 5 fields, those being: project name, square inches, client name, and weight. An example would be: Project 1, 100 sq inches, Client A, 50 lbs Project 2, 200 sq inches, Client B, 100 lbs Project 3, 300 sq inches, Client C, 150 lbs Etc. Then, we’d have a second collection of data that would branch off of the first set. For instance, the data might be sorted into something like 4 fields, being: brand new design, concept design, restoration, or simple cleaning. Finally, a third set of data would branch off of this information, detailing that each of the aforementioned categories have their own data. Such as, brand new design projects use X brand of glue, Y brand of paint, and are always Z color. Whereas, simple cleaning projects might use a totally different brand of glue, paint, and color. Now, my question is, is it possible in MS Access to be presented with all of the data based on what I ask for? Such as, say, I want to view all projects that have used X brand of glue. Am I able to create a database that will pull that up? Or if I wanted to view all brands of paint used ONLY in cleaning projects? Essentially, is it possible to create a database that can show me any combination of information based on what I ask for, creating relationships with one another to search both forwards and backwards with simplicity? If so, what research should I do to approach this, or what other direction do you suggest that I go in if it is not possible? I appreciate the help :)FraudThrottle Block SP/OD - 2+ Months Unresolved - Cases #2604230040009484, #2605260040000004
Summary: My organization's SharePoint and OneDrive access has been completely blocked for over 2 months due to a FraudThrottle flag. This is a production-blocking issue that standard SMB support has been unable to resolve despite two open support cases. Details: - SharePoint Online and OneDrive for Business are entirely inaccessible across the tenant - No downloads, uploads, or sync operations work - The block is caused by a FraudThrottle security flag triggered on our M365 E5 Developer trial subscription (purchased directly from Microsoft, not via CSP) - Support has confirmed the FraudThrottle block but has been unable to escalate or resolve it - The subscription status shows Active, but the FraudThrottle flag overrides access Cases: - Case #2604230040009484 (original) - Case #2605260040000004 (follow-up) What I Need: Escalation to the FraudThrottle/Identity protection engineering team to review and clear the false-positive block on our tenant. Standard support tiers have exhausted their ability to resolve this. Has anyone else experienced a similar FraudThrottle block on a dev/trial subscription? Any suggestions on how to expedite escalation to engineering? Thank you.
Office 2019 Home & Business for Mac – activation after erased old Mac
Hello, I own a perpetual Office 2019 Home & Business for Mac license, linked to my Microsoft account on 6 February 2022. The old MacBook where Office was activated was completely erased before being sold. I now need to activate Office on a new MacBook, but Word and Excel say that no license was found. Microsoft support told me that the license is limited to one device and cannot be reset. I understand the one-device limitation and confirm that Office is no longer installed or used on the old Mac. Could someone confirm whether a retail Office 2019 Home & Business for Mac license can be transferred to a replacement Mac after the old Mac has been erased? If yes, what is the correct activation or deactivation procedure when the original Mac is no longer available? The product is visible under Services & subscriptions in my Microsoft account. Thank you.
I received 2FA request but I can't identify the source
Since a couple of weeks, I've started received unwanted prompt on my phone to "confirm my identity": asking me to approve (second factor). Obviously, this isn't me and I reject those. At first, I was thinking it was just some phishing/stuffing attack, but I tried to find out how I could see those attempts and it is impossible to see "failed attempt" on the Windows Account web page or on the 2FA application. I have no clue how to investigate this, I would like to confirm what is the "source" of these attempts. Is there any way to have more extensive logs?
Odd pasting of things as images
This just started on specific page of one specific workbook, but now happening on completely new workbook. If I select a cell and copy and paste it puts it as an image in the cell. If I right click to paste I dont get the usual choices of test, formula, format etc I just get paste picture in cell or paste (which pastes an image) I've done a full reinstall and now it seems to be alternating between normal copy and copy as image if I do Ctrl C. The clipboard shows an image and then text in the history. I've disabled all com addins except dropbox. Driving me nuts as been getting slowly worse over last few months. Any ideas appreciated
HELP WITH EXCEL
Struggling to do a simple transition in Excel if anyone can give some advice: I have 3 items I need to run up & down instead of across... is there any easy way ??? So I need the Name and two of the xx Boxes to run from top to bottom... I did the first two but I did them cell by cell.... is there a formula that will take the entire thing and create what I need? Adriana Zaragoza Lopez Alejandro J Escobedo Alyssa Christina Amber H McCord Ana C DePaz xx xx xx xx xx xx xx xx xx Adriana Zaragoza Lopez xx xx Alejandro J Escobedo xx xx
Why is Excel suddenly calculating much slower than before?
I've noticed that one of my workbooks has become significantly slower over the past few weeks. It's around 20 MB, contains several PivotTables, XLOOKUP formulas, and conditional formatting. Simple edits now take a few seconds before Excel responds, even though my PC isn't under heavy load. Has anyone experienced something similar? Are there any common settings or features that typically cause this kind of slowdown? Any suggestions would be appreciated.separate columns in excel (imported from .txt file)
Hi all. I have a a table to bring in from a .txt file lots of lines with an excerpt below. I have tried to import data and copy paste etc and then tried to separate columns using delimiters and also number of characters but there is no consistency in the numbers in the columns, it keeps separating different rows differently (ie if i use space the title of the object on the 2nd row may have two or three words so using space as a delimiter is out, same for the number of characters and position). Any suggestions - is too much data to try and clean up by doing one of the above then trying to tidy it!Chart plotting values in wrong place according to axis?
I have this chart in excel that is being produced from a table in another tab in the same workbook. It has simple date in one column and values in another. When I hover over the plots for the MailChimp line the value displays correctly (e.g. 1344 in the screengrab for 25/6/26 datapoint) but the plot is between 2500 and 3000 on the graph according to the axis. This isn't happening for any other lines on the graph for any other values, only for the Mailchimp line. Any ideas how I can rectify this or what could be going wrong?
Restrict Editing of styles, allow new breaks, TOCs, etc.
I've restricted editing to a selection of styles in my Word template. This, however, also restricts some key essential functions, for example, you can't add in a new Table of Contents or add in page or section breaks. Is there any way to just limit the Font and Table styles, while allowing everything else?How can I remove the shortcuts with AltGr?
Guys, I have to use a new keyboard (Greek one) for some academic research and some accents conflicts with the AltGr + shortcuts. There's a way that I can just remove them all? I've tried to find and remove the shortcuts for Add a New Commentary (AltGr + A) and the topic structure (AltGr + o) but I can't find them in the list of shortcuts (Options > keyboard shortcuts > Personalize) I really need that ;(Access VBA performance dramatically slowed since June Update
We are running an access based application with a large vba project. One customer with four different instances of this project experience extreme slow down in performance on all instances during the last week. We made no changes. The Microsoft Office Update was applied automatically. We believe the problem happened then. We have tried reverting to several different previous versions of Office but symptoms still remain.sum function with text
total noob here... after a quick search, i didn't find anything on this... i want to do a sum formula, but i also want to add text to the cell after the sum is completed. is there a way to add this to the formula? do i just do the sum formula, then go back and add the text to the box or will that throw an error? do i just add the text to the cell next to the formula? thanks in advance!Help needed to filter in Excel please
How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LUGS, RIG 143 18600-Savanna, REPAIR JACO CATWALK SKATE ASSEMBLY, 653 18601-Savanna, REPAIR BAIL TILT CYLINDER, 653 18602-NS Modular, 8" LTC, 6PCS And I only want to see "Ensign" jobs. Thank youWord Templates Opening Multiple Times
Recently upgraded some templates from Word 2010 and 2003 (yeah, I know) to 2016 and 365 with, frankly, disappointing results. :o/ Since 2003 we've been using a pair of macros to merge some smaller files, doing some automated and manual clean up then running another macro that saves them back to the individual files. BUT, in 2016 and 365 when the macro creates a new document with the very basic command like this: Set NewDoc = Documents.add TemplateName.dotm A new document is created with the template attached, but as soon as it's saved, THE TEMPLATE IS NO LONGER ATTACHED! The only way to get the template to stay attached is to give the full path of the template, which then opens (inexplicably) a second version of the template. There are time when Word gives messages during macros that the template is read-only when a new document is created based on the template. Isn't that kind of the whole purpose of a template? To create similar documents based on, gosh, well, a TEMPLATE?! Is this all new "security" (and I use the term lightly) measures? Does anyone know if there is a way to make the "modern" versions of Word work like to the "good 'ol days" where templates just worked and Word didn't open multiple versions of the same template file and give read-only messages? With the help of a network admin we've done everything we could think of to try and convince Word that various network drives are "safe." Sorry for the snark, but it is immensely frustrating that code we've relied on 20 years all of a sudden doesn't work. Thanks for any ideas or insights. Best, -KenHow to edit an embedded textbox
Years ago I made an invoice form (actually I used an Excel template and modified it) that has an embedded text box containing 3 lines: address, city - state - zip, and a phone number. I want to change the phone number, but for the life of me I can't remember how I entered the info to begin with, nor can I figure out how to edit it. When I click on it the address bar reads =EMBED("Forms.TextBox.1", ""). Can anyone please tell me how to change the phone number in this textbox? This has gotten very frustrating. Thanks in advance.
Excel worksheet protected but can't use text to column function
HI I have a worksheet that several people use that I need to protect. There are formulas and a pivot table. I have been able to lock what I need and am able to refresh the pivot table but I can not use the "text to column" function in the raw data as its greyed out. The area in question are not locked cells but the function is still unavailable. We need to be able to use the text to column function but I also need the sheet locked to protect the formulas.Using Graph Delta Queries with Entra ID Groups
Delta queries are a Microsoft Graph mechanism to allow applications to query resources to find objects that have changed since a baseline was established. The technique is most useful for applications that need to synchronize a local store with online content. It’s not an appropriate method to use for reporting changes to Entra ID groups because knowing that an object changed doesn’t mean much by itself. https://office365itpros.com/2026/06/25/graph-delta-queries-entra-id-groups/
Recent Blogs
- Get started with Microsoft 365 Backup: 10 essential tips on recovery, compliance, scalability, and setup.Jun 26, 2026
- Microsoft 365 is evolving to support AI model choice, giving organizations more flexibility while maintaining enterprise-grade governance.Jun 25, 2026
