Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it.

​Hi, I have a formula =’Child 40′ !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I’m stuck on how to do it.   Read More

​

My organization’s Board of Directors uses Vieth (CPanel) for our email domain and server. We are hiring a new Executive Director and want to purchase Microsofit 365 for nonprofits to provide her with everything to be successful, including the same email domain as the Board. I’ve heard that if I switch the email domain into Microsoft, then no emails will go into the original email provider. Does this only happen to the individual email that was moved over to Microsoft, or to all of them?

Our ideal situation:

– email address removed for privacy reasons is on Microsoft 365 with Outlook and sends/receives emails

– email address removed for privacy reasons is on Vieth (CPanel) and sends/receives emails

I want to avoid a situation the discontinues the ability for our Board members to continue using the original domain if it is overridden by the Microsoft one.

I hope this was clear! I appreciate and reassurance or guidance. Thank you in advance!

​My organization’s Board of Directors uses Vieth (CPanel) for our email domain and server. We are hiring a new Executive Director and want to purchase Microsofit 365 for nonprofits to provide her with everything to be successful, including the same email domain as the Board. I’ve heard that if I switch the email domain into Microsoft, then no emails will go into the original email provider. Does this only happen to the individual email that was moved over to Microsoft, or to all of them? Our ideal situation:- email address removed for privacy reasons is on Microsoft 365 with Outlook and sends/receives emails- email address removed for privacy reasons is on Vieth (CPanel) and sends/receives emails I want to avoid a situation the discontinues the ability for our Board members to continue using the original domain if it is overridden by the Microsoft one. I hope this was clear! I appreciate and reassurance or guidance. Thank you in advance!  Read More

​

Dear All,

This is a follow-up from post https://techcommunity.microsoft.com/t5/microsoft-365/microsoft-word-getting-rid-of-unused-fields-in-equations-small/m-p/4269588#M54220

(which I believe is not seen anymore since a first solution was proposed))

Apparently due to an Apr 2024 bug in Word, “placeholder” boxes in Word equations are displaying when printed or converted to PDF when they did not used to. I’m trying to get a working macro to detect such empty fields and delete them (or at least, populate them with an empty space ” ” so that the small dotted squares don’t show anymore).

I’m trying to have a working macro, unfortunately without success yet.

Equations are indeed detected, if I display them I see their fields (all in 1 MsgBox).

Now, the eq itself will not be “empty”, some of of the eq fields might be.

I cannot find a way to go through each field of each equation, and then delete (or assign ” “) to each empty field.

Your opinion and help on this would be most welcome!

Thank you!

Sub SearchEmptyFields()
Dim eq As OMath

'Trying to define a range to go through eq fields
Dim r As Range

For Each eq In ActiveDocument.OMaths
    'This displays all fields of the current eq
    MsgBox ("Found: " & eq.Range.Text)
    'Trying to get through each field of the current eq... without success
    'For Each r In eq.Rang."element???"
    '    MsgBox ("Range: " & eq.Range.element.Text)
    '   Do a "delete" or put field value to " "
    'Next r
    Exit Sub
Next eq

​Dear All, This is a follow-up from post https://techcommunity.microsoft.com/t5/microsoft-365/microsoft-word-getting-rid-of-unused-fields-in-equations-small/m-p/4269588#M54220(which I believe is not seen anymore since a first solution was proposed)) Apparently due to an Apr 2024 bug in Word, “placeholder” boxes in Word equations are displaying when printed or converted to PDF when they did not used to. I’m trying to get a working macro to detect such empty fields and delete them (or at least, populate them with an empty space ” ” so that the small dotted squares don’t show anymore). I’m trying to have a working macro, unfortunately without success yet.Equations are indeed detected, if I display them I see their fields (all in 1 MsgBox).Now, the eq itself will not be “empty”, some of of the eq fields might be.I cannot find a way to go through each field of each equation, and then delete (or assign ” “) to each empty field. Your opinion and help on this would be most welcome! Thank you!  Sub SearchEmptyFields()
Dim eq As OMath

‘Trying to define a range to go through eq fields
Dim r As Range

For Each eq In ActiveDocument.OMaths
‘This displays all fields of the current eq
MsgBox (“Found: ” & eq.Range.Text)
‘Trying to get through each field of the current eq… without success
‘For Each r In eq.Rang.”element???”
‘ MsgBox (“Range: ” & eq.Range.element.Text)
‘ Do a “delete” or put field value to ” “
‘Next r
Exit Sub
Next eq   Read More

​

गूगल पे से गलत पेमेंट हो जाए तो क्या करें?

गूगल पे से गलत पेमेंट हो जाए तो क्या करें? – आप गूगल पे हेल्पलाइन नंबर ( +91 O9339-176-804 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,,

​ गूगल पे से गलत पेमेंट हो जाए तो क्या करें?गूगल पे से गलत पेमेंट हो जाए तो क्या करें? – आप गूगल पे हेल्पलाइन नंबर ( +91 O9339-176-804 (भाषा: हिंदी और अंग्रेजी) पर भी कॉल कर सकते हैं।… ,,,  Read More

​

Hi everyone, I’m new to powershell, I would like to know how to automatically load the modules I load with import-module in each instance; if I load the modules with import-module, when I close the instance I lose the module. I would like to know how to permanently load, for example, the KPI module in the $Env:PsModulePath variable. Obviously the question is answered to all the modules that I always want to keep in section even when I start the computer. I hope for an answer

​Hi everyone, I’m new to powershell, I would like to know how to automatically load the modules I load with import-module in each instance; if I load the modules with import-module, when I close the instance I lose the module. I would like to know how to permanently load, for example, the KPI module in the $Env:PsModulePath variable. Obviously the question is answered to all the modules that I always want to keep in section even when I start the computer. I hope for an answer  Read More

​

Hello Team,

As a Microsoft Solutions Provider, I am in the process of designing a detailed M365 Power User Model Concept aimed at enhancing an organization’s current M365 environment with a focus on scalability and sustainability. The primary objective is to establish a Power User model to drive organizational efficiency, optimize user engagement, and leverage advanced M365 capabilities.

This concept will include a structured approach to implementing the Power User model as part of a comprehensive upgrade to the latest M365 framework. Your expertise and consultation on the development and deployment of this model would be greatly appreciated.

Thank you for your insights.

Best regards,

​Hello Team,As a Microsoft Solutions Provider, I am in the process of designing a detailed M365 Power User Model Concept aimed at enhancing an organization’s current M365 environment with a focus on scalability and sustainability. The primary objective is to establish a Power User model to drive organizational efficiency, optimize user engagement, and leverage advanced M365 capabilities.This concept will include a structured approach to implementing the Power User model as part of a comprehensive upgrade to the latest M365 framework. Your expertise and consultation on the development and deployment of this model would be greatly appreciated.Thank you for your insights.Best regards,  Read More

​

Been beating my head against a wall for a few days trying to figure out how to get a dependent drop-down list to function in the Desktop Office 365 version of Excel.

I’ve finally found something that’s very close to working, using an XLOOKUP function that checks the adjacent cell, checks for a match, then outputs everything under that match. That works really well.

However my final hurdle, and the one that seems to be a recurring problem across all the methods I’ve tried, is getting the data validation to work when dragged down to other cells.

For my first column, that drags down perfectly well – since its just choosing from a static range. However, the second column doesn’t work like that. It only ever reads one cell, the cell it was entered with.

When I enter Data validation and select a cell, it has dollar signs next to both figures. I was reading that the dollar sign sets a value as absolute, so doesn’t shift when dragged down. However, Office 365 won’t let me remove the dollar signs from the validation.

How I’ve got it set-up in my Data Validation at the moment (that works for one row) is:

=XLOOKUP($A$3,Class,Subclass)

(Class being the static dropdown list, Subclass being the dependent dropdown list).

I can’t remove either of the $ signs without it refusing to accept it. Is there a work around to this, or another way to tell a cell “Hey, you’re looking for the cell to your left”.

As an alternative “Me thinking of things that probably won’t work” solution – where I have the XLOOKUP set up in the sheet, the data is descening vertically. I can drag it across horizontally, but that won’t work for how I have the table-setup. I was wondering if it was possible to have the XLOOKUP present its data in the columns to the right of it, instead of below. Then I can at least just drag that formula downwards maybe and see if that works?

​Been beating my head against a wall for a few days trying to figure out how to get a dependent drop-down list to function in the Desktop Office 365 version of Excel. I’ve finally found something that’s very close to working, using an XLOOKUP function that checks the adjacent cell, checks for a match, then outputs everything under that match. That works really well. However my final hurdle, and the one that seems to be a recurring problem across all the methods I’ve tried, is getting the data validation to work when dragged down to other cells.For my first column, that drags down perfectly well – since its just choosing from a static range. However, the second column doesn’t work like that. It only ever reads one cell, the cell it was entered with. When I enter Data validation and select a cell, it has dollar signs next to both figures. I was reading that the dollar sign sets a value as absolute, so doesn’t shift when dragged down. However, Office 365 won’t let me remove the dollar signs from the validation. How I’ve got it set-up in my Data Validation at the moment (that works for one row) is: =XLOOKUP($A$3,Class,Subclass) (Class being the static dropdown list, Subclass being the dependent dropdown list). I can’t remove either of the $ signs without it refusing to accept it. Is there a work around to this, or another way to tell a cell “Hey, you’re looking for the cell to your left”. As an alternative “Me thinking of things that probably won’t work” solution – where I have the XLOOKUP set up in the sheet, the data is descening vertically. I can drag it across horizontally, but that won’t work for how I have the table-setup. I was wondering if it was possible to have the XLOOKUP present its data in the columns to the right of it, instead of below. Then I can at least just drag that formula downwards maybe and see if that works?                     Read More

​

Hi,

I have different items which needs to be packed in different bags based on the following criteria. I have an itemized spreadsheet with the weight of each item (attached in link). I am looking for a solution to get the items packed in bags, fulfilling the criteria as mentioned below. For that reason, I would like to get which bag can contain how many items

– packet of items to be randomly packed in each bag such a way that the total weight shall not exceed 2.5 kg.
– each bag shall have mix of items from each category with at least 2 category items in each bag.
– Bag numbers shall be sequentially assigned in column F based on the first number which is manually assigned. (in example the bag number starts with 4001),

To achieve the desired result can formula be used or VBA is required? Appreciate, any ideas /solution to get the desired result.

Thanks in advance. https://1drv.ms/x/c/5184dd66ded11ae2/EbsnMRLq3VBNnhyOCHn1Fj0BpqL0z-uH3nsfZHQVnB2yRQ?e=poC4A4 

​Hi,I have different items which needs to be packed in different bags based on the following criteria. I have an itemized spreadsheet with the weight of each item (attached in link). I am looking for a solution to get the items packed in bags, fulfilling the criteria as mentioned below. For that reason, I would like to get which bag can contain how many items- packet of items to be randomly packed in each bag such a way that the total weight shall not exceed 2.5 kg.- each bag shall have mix of items from each category with at least 2 category items in each bag.- Bag numbers shall be sequentially assigned in column F based on the first number which is manually assigned. (in example the bag number starts with 4001),To achieve the desired result can formula be used or VBA is required? Appreciate, any ideas /solution to get the desired result.Thanks in advance. https://1drv.ms/x/c/5184dd66ded11ae2/EbsnMRLq3VBNnhyOCHn1Fj0BpqL0z-uH3nsfZHQVnB2yRQ?e=poC4A4   Read More

​

Ever since group based licensing was moved from Entra to 365 admin, it’s no longer possible to apply licenses to to 365 groups. This is clearly broken and needs fixing. What’s the process to raise this with Microsoft? I tried using Graph but that’s also broken, even when following the MS doc.

I raised a support case but they guy that called back was absolutely useless, didn’t even know what I was talking about.

​Ever since group based licensing was moved from Entra to 365 admin, it’s no longer possible to apply licenses to to 365 groups. This is clearly broken and needs fixing. What’s the process to raise this with Microsoft? I tried using Graph but that’s also broken, even when following the MS doc.I raised a support case but they guy that called back was absolutely useless, didn’t even know what I was talking about.  Read More

​

I am toying with the idea of preparing a comprehensive excel workbook for preparing a computation of income, adjustments, deductions, taxes and credits similar to a software helping to prepare 1040 return. My idea is not exactly to prepare a tax forms for submission but a computation summary of four to five pages which helps the tax payers to appreciate their income and taxes (as against 200+ pages of tax return). Technically it will be a full fledged software but will be also a very good review and visulation tool and mybe a tax planning tool later. Is excel a good place to do that? Will python with excel be able to handle? I am a tax professional but not a tech guy. I am only looking at Federal preparation as of now.

​I am toying with the idea of preparing a comprehensive excel workbook for preparing a computation of income, adjustments, deductions, taxes and credits similar to a software helping to prepare 1040 return. My idea is not exactly to prepare a tax forms for submission but a computation summary of four to five pages which helps the tax payers to appreciate their income and taxes (as against 200+ pages of tax return). Technically it will be a full fledged software but will be also a very good review and visulation tool and mybe a tax planning tool later. Is excel a good place to do that? Will python with excel be able to handle? I am a tax professional but not a tech guy. I am only looking at Federal preparation as of now.  Read More

​