rss.livelink.threads-in-node

Bold Duplicates (Conditional Formatting)

Tony2021 — Sun, 26 Apr 2026 14:59:34 GMT

Hello experts

I have a form based on qryLCAmends

I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID

here is what I have but it doesnt bold anything:

DCount("*","qryLCAmends","[LCID]=" & [LCID] & "[LCNo]='" & [LCNo] & "'")>1

LCNo is text.

I am using the "expression" in conditional formatting:

Example:

How can I do this with conditional formatting?

Employee Onboarding in a Day: Creating Role-Specific Training Guides from SharePoint Content

JohnNaguib — Sun, 26 Apr 2026 06:30:47 GMT

In today’s fast-paced business environment, the expectation to get new employees productive as quickly as possible is higher than ever. Yet, onboarding often remains one of the most fragmented and time-consuming processes within organizations. Information is scattered, training materials are outdated, and new hires are left navigating a maze of documents with little guidance.

https://dellenny.com/employee-onboarding-in-a-day-creating-role-specific-training-guides-from-sharepoint-content/

Word freezes or crashes when pressing the G key in the file search

S-Mania — Sun, 26 Apr 2026 04:41:22 GMT

When pressing the letter G in the file search on Word, it either just freezes and doesn't respond or crashes immediately. Regardless of whether Word is in Safe Mode or not. It also pops up a "Word couldn't start last time" pop-up when I try to open the app again and asks if I want to open it in Safe Mode. Which, as I said, still has the same problem.

As far as I can tell, that's the only issue with Word. Everything else works great so far.

This does not happen with other apps like PowerPoint or Excel. I have only recently reinstalled all the apps and it does not seem to have helped.

Windows 11 25H2

Access fixes released in Version 2604 (Build 16.0.19929.20090)

lindalu-MSFT — Sat, 25 Apr 2026 05:59:52 GMT

Bug Name	Issue Fixed
Values display in the wrong control when using a form as a sublist	When a form was used as a sublist (subdatasheet), field values could display in the wrong control, showing data in incorrect positions. Values now display in the correct controls.
Applications that use the Access Database Engine (ACEOLEDB) terminate unexpectedly on exit	Third-party applications using the Access Database Engine (ACEOLEDB) provider could terminate unexpectedly when closing. The shutdown sequence has been corrected.
Long Text field corrupted when a query updates a record while a user is editing it	When a query updated a Long Text field on a record that was simultaneously open for editing, the field data could become corrupted. The record update now correctly handles concurrent access to Long Text fields.
Rendering errors with Aptos (Detail) font	Controls using the Aptos (Detail) font variant could render incorrectly, with characters appearing misaligned or garbled. The font rendering has been corrected.
Standard colors in Access didn't match other Office apps	The standard color palette in Access used different color values than other Office applications like Word and Excel. The color palette has been updated to match the rest of Office.
Option Group with Vertical Anchor Bottom: option buttons show incorrect visual state after clicking	When an option group control had its Vertical Anchor property set to Bottom, clicking an option button would not correctly update the visual state of the buttons. The visual state now updates correctly regardless of the anchor setting.
Query Design: Insert/Delete Columns don't work when ribbon is set to Show Tabs Only	In Query Design view, the Insert Columns and Delete Columns commands on the ribbon did not work when the ribbon display option was set to "Show Tabs Only." The commands now work correctly regardless of ribbon display mode.
SQL View: Ctrl+K should toggle pretty formatting off/on	In the Monaco SQL editor, the Ctrl+K keyboard shortcut did not toggle SQL formatting. Ctrl+K now correctly toggles pretty formatting on and off.
Monaco editor incorrectly converts Unicode characters in SQL view	When switching between Design View and SQL View, the Monaco SQL editor could incorrectly convert certain Unicode characters, corrupting the SQL text. Unicode characters are now preserved correctly.
Importing text files with Unicode characters in the filename fails	Attempting to import a text file whose filename contained certain Unicode characters would fail. File imports now handle Unicode filenames correctly.
Added VarP and StDevP to the Totals query aggregate dropdown	The VarP (population variance) and StDevP (population standard deviation) aggregate functions were missing from the Totals row dropdown in Query Design view. They have been added alongside the existing Var and StDev options.
Added VarP and StDevP to the datasheet totals row dropdown	The VarP and StDevP aggregate functions were missing from the Totals row dropdown in Datasheet view. They have been added to match the options available in Query Design view.
Access hangs at shutdown when VBA holds temporary DAO field references	Access could hang during shutdown when VBA code created temporary DAO field references. The shutdown process now correctly cleans up temporary field references.
Full Screen Mode ribbon display option does nothing in Access	Selecting "Full Screen Mode" from the ribbon display options had no effect in Access. This option now works correctly, hiding the ribbon to maximize the available workspace.

Spreadsheet corrupts upon saving it

Beebatron — Fri, 24 Apr 2026 17:40:33 GMT

After reaching out to MS Support regarding this, they suggested I post my issue over here.

Starting this week, a spreadsheet that I've been using for years is no longer working. When I launched it yesterday, it opened without issue as it usually would, I was able to make some edits and save. But after opening it up again, it came up with the prompt: "We found a problem with some content. Do you want us to try to recover as much as we can?". After clicking on Yes, comes 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)".

At this point, I restored a saved copy from backup (from around five days prior). Once again, file opened and was working fine, but only after saving it would it corrupt upon reopening. To make the issue even more strange, this same behavior is now retroactively occurring if I try to open a template version of this spreadsheet I had saved from 2024, or even as far as 2020. It's almost like an update was pushed which made objects used in this spreadsheet retroactively no longer viable and corrupted.

This behavior is not occurring on new spreadsheets I create, nor other ones I tested that are completely different to this specific spreadsheet I'm referencing above; though I haven't tested every single spreadsheet on my system.

I've tried repairing MS Office, I've tried saving as different extensions (i.e. from xlsm to xlsx), but no matter what I try, this spreadsheet and any version of it historically saved (and I have years worth of copies) are now all exhibiting this error if I open and save them.

Thoughts?

Converse naturally across languages with consecutive interpretation

harinlee — Fri, 24 Apr 2026 15:30:00 GMT

Hi, Insiders! I am Harin Lee, a Principal Product Manager on the Microsoft Teams team. I’m excited to share a new way to collaborate across languages in your meetings: consecutive interpretation in Interpreter.

Keep two-language meetings flowing with consecutive interpretation in Teams

Interpreter brings speech-to-speech translation to Teams meetings so everyone can participate in the language they're most comfortable using. Consecutive interpretation is a new mode in Interpreter for Windows, Mac, and the web that helps participants collaborate more naturally in meetings with two spoken languages. With this update, Interpreter now supports two modes: real-time simultaneous interpretation (launched last year) and a new consecutive interpretation mode designed for back-and-forth conversations.

With consecutive interpretation, the translation begins after each speaker finishes speaking. This creates a turn-based flow that more closely reflects how people naturally communicate in multilingual conversations. In addition, consecutive interpretation brings Interpreter onto the meeting stage for everyone to see and hear, making it easier to follow, participate, and stay aligned.

How it works

After the meeting starts, as the meeting organizer you can click the More menu and select Turn on Interpreter.

Select Consecutive interpretation, choose the two spoken languages from the drop down menus, and click Turn on.

Interpreter will be added to the meeting stage, and everyone will be notified it’s on.
Take turns speaking, and wait for Interpreter to translate after each speaker.

Tips and tricks

Consecutive interpretation is designed for interactive, two-way conversations across a language pair (E.g., Spanish and English). Simultaneous interpretation is suited for broadcast-style, listening scenarios across multiple languages.

Known limitations

Consecutive interpretation is available across 10 languages, supporting any language pair between them. Supported languages include Chinese (Simplified), Chinese (Traditional), English, French, German, Italian, Japanese, Korean, Portuguese and Spanish.

Requirements

To enable the Teams client for the Public Preview, IT administrators must enable Show preview features in their update policy. Learn more.

For Targeted release, global admins can go to the Microsoft 365 admin center and give access to a select set of individuals or the entire organization. Learn more.

Availability

Consecutive interpretation is available for meeting organizers with a Microsoft 365 Copilot license and Teams clients enabled for Public Preview.

During the preview period for consecutive interpretation, access is subject to available service capacity. Beyond preview, additional details will be shared when the feature becomes generally available.

Features covered in this blog roll out over time to enable us to monitor quality and performance, so some preview features may not be available to you right away. Also note that features may be paused, adjusted, or removed as part of that process.

Feedback

We’d love to hear what you think about this feature! Select the thumbs up or down buttons in your Copilot response, or select Settings and more > Feedback in the top-right corner of the Teams app, and then select either Report a problem, Give a compliment, or Suggest a feature to share your thoughts.

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!

"Clear Filter From" Option is Never Available

VOwens1 — Fri, 24 Apr 2026 14:32:35 GMT

Once a column is filtered, the option to remove that filter just from that column is always greyed out in my Excel (Microsoft 365, v2604, Build 19929.20090).

I have seen multiple references advising to remove protection, check for hidden columns, or ungroup workbooks. None of these apply, since I have also tested this with a new worksheet containing a single column, with nothing possibly hidden, and with no shared access. Here is a screen shot of what I see:

Thanks to anyone who may have some advice on how to re-enable this feature.

Functionality to mark a slide complete

ABDAF — Fri, 24 Apr 2026 13:36:48 GMT

I do not believe this functionality alread exists but I'm quite sure I'm not the only one that would love to have it added.

Now when working in a larger powerpoint slide deck I start with adding a "traffic light" to my slides that's red, and when the slide is finished I turn it green. Then, before presenting I have to delete all traffic lights before the deck is truly ready. This way I can keep track of which slides still need attention and prevent myself from spending time on slides I shouldn't.

Now I believe it would be very nice if it was a built in feature where you can mark individual slides as "complete / final" or "needs attention" with visual feedback of this status in for example the navigation pane.

How do others handle this and is there a trick I do not know of?

Spreadsheet Corrupts Upon Saving

Beebatron — Fri, 24 Apr 2026 12:06:22 GMT

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?

ODBC error (incorrect syntax) since 2604

EzAccessGideon — Fri, 24 Apr 2026 11:18:52 GMT

Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error

Run-time error '3155':
ODBC--insert on a linked table 'tablename' failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102)

I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem.

So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text.

I have this problem consistent on all apps and all tables where i have NVARCHAR(>255).

My solution is to go back to office release 2508 (semi annual support).

My Word table is messed up.

bopesones — Fri, 24 Apr 2026 10:48:31 GMT

My Word table is messed up. You can see the problem in the photo. The spacing is off at the top and bottom.

I can't move the column lines either, because that messes everything up. Older versions of the document look the same way. I need help urgently.

Entra and Microsoft 365 Could Improve License Reporting

TonyRedmond — Fri, 24 Apr 2026 09:10:53 GMT

License insights is a new feature in the Entra admin center. The Microsoft 365 admin center also shows some license insights in a dashboard card. The two views don’t line up. This isn’t very surprising because different teams generated the information, but it would sure be nice if Microsoft delivered comprehensive license reporting for Microsoft 365 tenants, including the Entra premium licenses.

https://office365itpros.com/2026/04/24/license-insights/

MC1269241 - Can't turn off antropic for agentmode

Emiliabergstrom — Thu, 23 Apr 2026 23:25:06 GMT

Hi,

I’m trying to figure out how to turn off the new feature where Anthropic is enabled by default for everyone in the EU for agent mode in excel and powerpoint, as described in the Message Center news in the title.

It is not possible to press Save when you have unchecked the setting unless you also consent to the terms of use, it is greyed out. Since we want the feature turned off, we do not want to agree to any terms of use.

Has anyone found a solution? This seems to be misconfigured.

Personal calendar

JO1902 — Thu, 23 Apr 2026 19:29:15 GMT

Hi,

I want to personal calendar with notification on the day.

Can someone please help with this.

Thanks

Jyothsna

What is this Madness? Weird Average and Sum results

LYorkToenniges — Thu, 23 Apr 2026 18:35:40 GMT

What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!

Register today for the Microsoft 365 Archive + Orchestry webinar

wbaer — Thu, 23 Apr 2026 17:58:36 GMT

Join us for a live webinar on May 7, 9:00 am PDT, with Trent Green, Microsoft, and David Francoeur, Orchestry, to learn more about what file-level archiving does, how it works, and how to turn it into a scalable, automated strategy across your tenant.

Register now for the May 7 webinar [orchestry.com]

File-Level Archival: The Next Frontier of Microsoft 365 Storage Optimization
May 7, 2026 | 9:00 AM PDT

Optimizing storage costs with file-level archiving

We recently launched the public preview of file-level archiving, a new way to help reduce additional Microsoft 365 storage costs, without deleting content. Microsoft 365 Archive allows end users and admins to move individual files into an archive cold storage on SharePoint and OneDrive for Business, while retaining visibility, search, and compliance posture.

We’re happy to work with companies, like Orchestry, to bring our customers archiving at enterprise scale.

Join Orchestry & Microsoft

Join David Francoeur, Head of Product Strategy & Innovation, Orchestry, and Trent Green, Principal Product Manager, Microsoft 365 Archive, Microsoft, to learn more about the following:

The difference between site-level vs. file-level archival
How file-level archival works: cold storage, reactivation, admin controls, and billing
Where native tooling breaks down and automated governance takes over
How to define rule-based archival criteria (inactivity, file type, file size)
Why archived content is excluded from Microsoft 365 Copilot and why that matters for AI readiness

Move beyond site-level cleanup with Orchestry and Microsoft 365 Archive. Help reduce additional SharePoint storage costs and keep the content that matters.

Register today.

We look forward to seeing you there!

I need Help with Cell Formatting to be able to copy

Kerry_Smith — Thu, 23 Apr 2026 16:58:09 GMT

I have a number in a cell

2022
	NET

260	$ 241.32

and I want to get the NET of that value by taking the 260 and multiplying it by another cell

Monthly Percentage

and subtracting that number from the original 260. I then want to be able to copy the formula and paste it down the column yet making sure that the 7% Cell remains constant unlike the 260 cell. I forget how to do that. Help

copying formulas

bob71 — Thu, 23 Apr 2026 15:19:20 GMT

how do i increase a number b1 in fomula

='725'!$G$64

i want to increase 725 by 1 when i bulk copy

725, 726, 727 etc

excel

bob71 — Thu, 23 Apr 2026 15:09:42 GMT

how do increase my formula by 1

this is my formula ='725'!$G$64

i want to increase 725 to 726 on so on

Word Version Incompatibility

flielguera — Thu, 23 Apr 2026 14:35:32 GMT

Good morning everyone, I've switched from Microsoft 365 Personal to Microsoft Plus 2021 Business. My question is, is there any incompatibility between the Word versions of these two services? I ask because when I try to work with a file saved as a "Microsoft Word 97-2003 Document," I get a memory error message. However, when I save the same file as a "Microsoft Word Document" and work with it, I don't get the error message.

Looking forward to your kind reply.

Fernando