Teams Client, Guest User access, Separate Tenant
Hey Team, I am trying to figure out what i am missing here. This is what we have. 2x Tenants with Enterprise E3 licenses Some user accounts are sync'd between the 2 tenants, not all users We have added a guest user, and we need his account to be able to access our Tenants teams. When he goes to the Teams Web Client, he sees his org and ours. However in the teams fat client, he is not able to switch from his home tenant (tenant.com) to our tenant (tenant-business.com). My question is how do i get our tenant to show up in his teams client? I tried having him login using his #EXT# guest account, but it requires a password. Thanks, Robert
Inconsistent behaviour of AccessRuntime and Access (Developer Version) - Office 365
I am using Access Version 2608 (Build 20326.20132) and I am having big problems because of a differnt behaviour of Runtime and Full (same version). When setting a short timer (for initialisation / 10ms) within the Form_Load event, the timer starts in the "Full-Version" of Access365 immediatly after finishing the Form_Load event (not further action in the other events). The Runtime-Versions don't accept the Timer-Value I set befor in the Form_Load event. Remark: With an old version (I don't know which one, because all customer PC were updated) it works perfekt, also with AccessRuntime. A very old customer installation (16.0.18827.20164) works perfekt. What can I do, because the application is broken down at many customer sites ... and I have to solve this problem very urgent.
Linked data not updating
Hi I have a rostering spreadsheet where each person has their own spreadsheet with their rota they select a shift in their spreadhseet. I have a main spreadhseet where I link each spreadhseet to my my main rota so I can see what shifts they have selecteeneed and be able to resolve any conflicts i.e 2 peole selecting sam eshift. The issue is when data is updated in the individual spreadhseet it is not pulling through to my main spreadsheet. I used Data and get data form Excel file to link the workbooks. Not sure what I am doing wrong When Dr Adams adds a Y in Thursday it is not showing in my spreadhseetBraille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!
Planning a Google Workspace to Microsoft 365 Migration? What Should You Consider?
Hi everyone, Has anyone recently migrated from Google Workspace to Microsoft 365? I’m interested in knowing what challenges you faced during the migration, especially around mailbox data, calendars, contacts, user mapping, or the final cutover process. For those planning the migration, what are the key things you recommend preparing before getting started? Would like to hear your experiences and suggestions.BigSpill: A 92‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 92 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficient tools that make sheet‑level formulas easier to read, more modular, and more dynamic. The library includes a mix of: quality‑of‑life helpers essential primitives mid‑level operators developer‑level tools a few functions you might not expect to see in Excel Who is it for? Everyone. BigSpill aims to make complex operations more approachable and expressive. A few examples from the library: Pairwiseλ Staircaseλ Grainλ PolarGridλ Convolveλ Foldλ Tessellateλ Revealλ Knapsackλ Magnifyλ Traverseλ The repository includes full documentation and 11 sample workbooks so you can explore the functions without setup. If you’re interested in experimenting with dynamic arrays, or LAMBDA workflows, feel free to take a look. Feedback and suggestions are always welcome. I've attached 1 onboarding workbook. There are 10 more at the link below. GitHub: BigSpill
Does a LET variable get computed even if it's only referenced inside IFNA's fallback argument?
In the formula below, expensiveMatch is defined in LET but only referenced as IFNA's fallback argument: =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), expensiveMatch, INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), IFNA(x, expensiveMatch) ) Question: When x resolves successfully (no #N/A), does expensiveMatch still get computed because it's a top-level LET variable - or does Excel skip it since IFNA's fallback argument is never reached? I know IFNA short-circuits its fallback argument, and LET avoids recomputing a variable if referenced multiple times - but I haven't found much documentation on the behavior of Let. Is the below a more efficient way to write the formula? =LET( matchRow, XMATCH(1, (A1=Sheet2!$A$1:$A$1000)*(B1=Sheet2!$B$1:$B$1000)), x, INDEX(Sheet2!$C$1:$C$1000, matchRow), IF(ISNA(x), INDEX(Sheet3!$C$1:$C$500, XMATCH(A1&B1, Sheet3!$A$1:$A$500&Sheet3!$B$1:$B$500)), x ) ) Is this restructuring necessary, or does the first version already skip the unused computation? Basically I'm wondering if Let computes lazily/defers calculation in the way SQL's optimizer works. Input from anyone with insight or knowledge into the calc engine would be greatly appreciated. Thanks (Currently on Microsoft Excel for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit)Zoom further in more Microsoft Access views
Zoom from 10% to 1000% Supported Access views can now be zoomed anywhere from 10% to 1000%, expanding the previous range of 50% to 500%. New 10%, 25%, and 1000% choices are available in the Zoom menu, and the status bar slider supports the full range. The expanded range is also available when configuring the default zoom level for a database. Zoom more types of forms Zoom is now supported in both continuous forms and popup forms. In a continuous form, zoom scales the repeating records and their controls together, making it easier to read individual records or see more records at once. Embedded continuous forms also scale with their parent form, keeping nested content visually consistent. Popup forms can be zoomed without changing their underlying design. Because popup forms do not use the standard status bar zoom control, you can zoom them with Ctrl+mouse wheel or the zoom keyboard shortcuts. Zoom reports in Report View Zoom is now available for reports in Report View, bringing reports in line with forms, tables, and queries. You can enlarge a report to inspect individual values or zoom out for a broader view of its layout and data. Reports displayed inside forms also scale with their parent, providing a more consistent experience for databases with nested forms and reports. Choose how you zoom Depending on the type of object you’re viewing, you can: Select a percentage from the Zoom menu on the ribbon. Drag the zoom slider on the status bar. Hold Ctrl and scroll the mouse wheel. Press Ctrl+Alt+Plus or Ctrl+Alt+Minus to zoom in or out. Press Ctrl+Alt+0 to return to 100%. With a wider range and support for reports, popup forms, continuous forms, and nested content, it’s now easier to tailor your Access workspace to the task at hand—whether that means focusing on the details or taking in the bigger picture.
Formatting issues in Word Microsoft 365 Copilot online.
I am experiencing formatting issues in Word (Microsoft 365 Copilot online). I am a student, and I have a problem formatting my thesis in M365 Copilot after previously working on this file on an older device with an older version of Word. I recently purchased a new laptop, where I no longer have access to that same version of Word. My only option now is to use Word in the browser. However, the file that formatted correctly on the old device is now not formatting properly. The automatic table of contents is breaking. After clicking “Update,” Word assigns random page numbers, most often all entries show as page “8,” or, for example, the “Introduction,” which is actually on page 3 (I manually set page numbering in the old version), suddenly appears as page 5 in the table of contents. Every chapter and subchapter is shown as being on the same page, usually page 8. The formatting options and capabilities also seem worse compared to the interface of the older version. The same issue occurs on my student account. Please help, I am currently writing my thesis.Tenant to Tentant Migrations - Which Third-Party Providers?
Hi there, We're going to be performing an O365 -> O365 migration for about 250 user accounts. I realise that we need to use third-party tools to do this and I've had experience using BitTitan.com for O365 migrations but the service is quite expensive and so I wondered if there were any other reasonably priced alternatives? We'd be looking at migrating Emails, Contacts, Calendar and personal OneDrives for all users. Thanks Olly
