RossCummingsOneIT

Life saver! I was just on the main Dell Driver site and not the drilled down BIOS page - much appreciated

Hi All, apologies if this is in the wrong part of the forum I have a 7470 AIO that has a BIOS failure - recovery page appears with 3 options to recover, rollback or go to factory defaults but all fail. I need to create a bootable USB to reinstall the BIOS but the exe I get from Dell once extracted does not have a .hdr file to rename to a .rcv file My machine is out of warranty so Dell support aren't being helpful, but I can't find the .hdr file anywhere and presumably I cannot just put the .exe into a bootable USB as it needs the .rcv file I can't get into any sort of MDT/F12 prompt, no F8 for CMD, no recovery options etc so my only option is to boot from USB to re-install the BIOS Any help would be appreciated!

Hello We have a customer with a sharepoint site with a tonne of contents that we need to migrate to a new tenant - is there a free tool that can do this or is it only possible by downloading files manually then using the sharepoint import tool to get it all back on the new site? Cheers Ross

Hi All, apologies for the lack of information here but i am not well versed in sysprep etc but just doing some research to try fix this issue. The built in OneDrive app that comes with Windows 10 seems to be being removed when we sysprep a new machine. We thought it was group policy based originally but building a PC on a workgroup still seems to remove the app as it is landing in the users app data. Has anyone else experienced this issue and maybe has a solution on how to stop it being removed - or have a way to get it reinstalled after a PC has been built? Thanks. Ross

Seb1780 - Good idea, next question is how to get a script to do this on multiple sheets. So if Sheet is Adam, and I also need it to do it on Sheet Craig, what is the correct way to do multiple sheets? I've tried commands, brackets, speech marks, can't quite figure it out Sub FindReplaceAll()'PURPOSE: Find & Replace text/values throughout a specific sheetDim sht As WorksheetDim fnd As VariantDim rplc As Variantfnd = "OK"rplc = "Not Checked"'Store a specfic sheet to a variable Set sht = Sheets("Adam") 'Perform the Find/Replace All sht.Cells.Replace what:=fnd, Replacement:=rplc, _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ SearchFormat:=False, ReplaceFormat:=FalseEnd Sub

Thanks - never really worked with macros in excel so not too sure how to do this - if anyone could suggest a quick one line i could start to edit that would be great

It's got Allow: List Source: =Control!$A$2:$A$6 (Theres a control sheet with the drop down options)

Hey Guys, apologies if this is in the wrong place. I have a spreadsheet where we are doing backup checks for our schools and it is essentially a sheet per technician with their list of schools and you can choose ok, not checked etc etc. I need to have a reset button where it will change all the dropdowns to Not Checked after a certain period of time - we will press this button manually. I have a script that does it, but the problem is each sheet has many rows, and in other sheets they have less, and it may change frequently, so ideally I need something that says reset all dropdowns to "Not Checked" instead of me having to put a range in for each sheet, as ideally i want one button to reset all the sheets and not one per sheet. This is what I have so far, which works perfectly for the range in question: Sub Reset_Dropdowns() Range("C4:L4").Value = "Not Checked" Range("C5:L5").Value = "Not Checked" Range("C6:L6").Value = "Not Checked"End Sub Is there something I can do to say reset all dropdowns in all sheets to Not checked? I tried doing A1:L200 as an example but it put Not Checked in every field and not just the dropdowns (I presumed "Reset_dropdowns" would reference dropdowns only) Thanks! Ross

MartinByard - works perfect, thanks!

Hey everyone, Sorry if this is posted in the wrong area, not sure where to put it. Trying to export some information from a powershell script into a csv but having a nightmare. Aim of script is to get pc name, serial number, make/model, ram & processor. Script runs fine but struggling to output it afterwards, wanting to avoid having to copy and paste it out at the end. Keeps outputting this at the end of my script: cmdlet Export-Csv at command pipeline position 1Supply values for the following parameters:InputObject: --- This is the script im running gwmi win32_bios -computername (PCNAME) | format-list serialnumber, PSComputerName, version gwmi win32_processor -computername (PCNAME)gwmi win32_physicalmemory -computername (PCNAME) | format-list capacityexport-csv -path (FILEPATH) --- would appreciate any help i can get!

Bit of a guess but i had a similar issue on windows 7 machines but it was related to a specific windows update not being installed on the problematic machines. had it recently too where it didnt install on one or two 10 machines and decided to just do it manually!

I've got one school that had to buy Smart learning suite 17.1 because they have many brands of touch screens that were not playing ball with 11.4(smart notebook), and now they work perfectly with SLS regardless of the brand of the board. I've not had one complaint about a feature not being available

Hi All, Trying to just get some info before I give this a go my self as it could be a huge waste of time. Can you have Mac OS running VirtualBox or similar, with a Windows 10 VM on which is a domain pc with direct access, will it work? My reasoning for looking into this is with GDPR coming in and everything portable needing encrypting on our network, FileVault sorts out the mac side but i'm struggling to bitlocker the windows side too without breaking the mac side. Second question leading on from that would actually be, can you have mac with bootcamp'ed Windows 10 with filevault and bitlocker both running? Thanks Ross