For anyone interested, it turns out that, in my case at least, the solution was "don't use Windows Easy Transfer". I had done a lot of customizing of my old platform, involving a lot of editing of permissions. WET doesn't transfer permissions and only part of those customizations, in such a way thatRead more
For anyone interested, it turns out that, in my case at least, the solution was “don’t use Windows Easy Transfer”. I had done a lot of customizing of my old platform, involving a lot of editing of permissions. WET doesn’t transfer permissions and only part of those customizations, in such a way that I think I wound up with sort of a corrupted mess. Since it doesn’t transfer permissions and you need to reinstall all your programs anyway, I don’t think there’s much point in using it. It’s not difficult to re-establish accounts manually and desktop preferences by exporting theme packs. Once I started customizing my third attempt at a fresh install, this time without WET, I had no problem at all setting up the proper permissions. Folder editing now works as it should.
There are multiple ways to remove 2 trailing zeros.It depends on whether you want to leave the new values in the original column or move them elsewhere.To leave them in the same column, follow these steps:1 - Select an empty cell and enter 100 2 - Copy the Cell3 - Select your original values4 - RighRead more
There are multiple ways to remove 2 trailing zeros.
It depends on whether you want to leave the new values in the original column or move them elsewhere.
To leave them in the same column, follow these steps:
1 – Select an empty cell and enter 100 2 – Copy the Cell 3 – Select your original values 4 – Right Click, choose Paste Special 5 – Check the Divide box 6 – Click OK
To have them end up someplace else, any of these methods, as well as many others, will work:
Divide by 100:
=A1/100
Use the LEFT function. Since LEFT returns a text value, multiply the result by 1 to turn it back into a number if required.
If the original value will always be 6 digits, extract the first 4:
=LEFT(A1,4)*1
If the original value will vary in length, return just the digits to the LEFT of the last 2:
=LEFT(A1,LEN(A1)-2)*1
After performing any of the “new location” methods described above, you can replace the original values as follows:
1 – Select the new values 2 – Copy 3 – Select the original values 4 – Right-click, choose Paste Special 5 – Check the box next to Values 6 – Click OK
A 25 foot range could be correct with less capable wireless routers. The best way to test this is to move the router closer to the television if possible. Moving it only a few feet can make all the difference. A range extender is an option but as pointed out already it will affect your connection spRead more
A 25 foot range could be correct with less capable wireless routers. The best way to test this is to move the router closer to the television if possible. Moving it only a few feet can make all the difference.
A range extender is an option but as pointed out already it will affect your connection speed considerably so probably not ideal.
I myself use an Ethernet Over Power (EOP) solution for this very reason. I get decent enough speed that I can send Bluray quality information through my homes electrical wiring to any room in the house without issue. I currently have three separate rooms in the house accessing my router at decent speeds.
Something like this would be ideal: http://m.newegg.com/Product/index?i… You can get these that will give you 500 and even 600 Mbps speeds if you need it.
Yeah, this question has come up before several times, there is no simple answer. Unless you are good with a soldering iron and can read electronic schematics, I would leave it alone.
Yeah, this question has come up before several times, there is no simple answer.
Unless you are good with a soldering iron and can read electronic schematics, I would leave it alone.
In an earlier thread you were asking for help with pasting data into visible cells. In this thread you say "I just used some macros in my spreadsheet to paste data in visible cells."Does that mean that your earlier issue has been solved?As far as this particular question, you can either remove the mRead more
In an earlier thread you were asking for help with pasting data into visible cells. In this thread you say “I just used some macros in my spreadsheet to paste data in visible cells.”
Does that mean that your earlier issue has been solved?
As far as this particular question, you can either remove the macros and save the file as a .xlsx or save the file as a .xls file which will retain the macros but not be seen as a .xlsm file. Whether the accepting application will know that that the macros are in the file is something you will have to test.
Removing the macros and saving it an .xlsx file should solve both issues: acceptance by the other app and prevention of further changes because the macro no longer exists.
Your 12Volt reading is fine in your BIOS at idle and it is a quality power supply. Your temps are good. Your internal GPU is 0.000 I assume because it is disabled due to your graphics card being your primary graphics. I do not see any special reason for the crashing but it does appear to be hardwareRead more
Your 12Volt reading is fine in your BIOS at idle and it is a quality power supply. Your temps are good. Your internal GPU is 0.000 I assume because it is disabled due to your graphics card being your primary graphics. I do not see any special reason for the crashing but it does appear to be hardware related. Here are a few things that MIGHT make a difference: (computer off and unplugged, ground yourself of any possible static charge) Clean the contacts on the memory with a soft pencil eraser, then pop them in and out of the sockets 4 or 5 times to burnish the sockets. Remove and reseat all connectors 2 or 3 times each including the modular ones on the power supply to rub them clean. Run Memtest86 to test memory, run through all tests at least once. Run your SSD management software to be sure it shows no issues. You can run it for a while in Safe Mode or off a Live Linux disk (not install) to see if you get the crash which may confirm it is hardware related.
Software related: Run Task Manager and under the Processes Tab identify the program or process that is using a lot of CPU. If you are not sure what it is, Google it. If it is not yours, not a necessary part of the system, you may want to uninstall it. If it is a program that you use but not continuously, go into its settings and uncheck “Start With Windows”, restart the machine and see if it makes any difference. You can also run CCleaner and use its Start Up feature to manage your start up programs. Please note that running the CPU at 100% for a reason is not bad and should not cause a crash unless it overheats or becomes starved for current.
CPU current related (Increasing the voltage slightly will lessen demand for current): If the CPU is reaching a state that is unstable under full load then it may help if you manually increase the VCore voltage by a very small amount (0.01 or 0.02) and see if it makes any difference. Here is something that may help you be more comfortable adjusting your VCore (CPU voltage): http://www.tomshardware.com/answers… Check Temps after adjusting voltage but a small increase should not effect it significantly.
You have to be a little bit crazy to keep you from going insane.
Sounds like normal.dot is corrupt. Just rename it to something else, and Word will recreate it the next time it opens.Also look here: http://www.askmefast.com/HiMy_broth...
Sounds like normal.dot is corrupt. Just rename it to something else, and Word will recreate it the next time it opens.
From the brief look-see/research I di on this I got the impression that it might have been viable with earlier versions of Outlook; even if one had to create/use a macro (as in one of the above links); or used an add-in item... But with 2010 version if appears that M$ (as per for most companies) decRead more
From the brief look-see/research I di on this I got the impression that it might have been viable with earlier versions of Outlook; even if one had to create/use a macro (as in one of the above links); or used an add-in item… But with 2010 version if appears that M$ (as per for most companies) decided to “phyxe sumat that wasn’t broke” – and thus what you’d like to do isn’t really viable…
It seems that in pre 2010 versions of Outlook M$ Word was the editor in full; whereas with 2010 and later there is some form of link with M$ Word but not as was with earlier Outlook.
Incidentally you’re not alone in wanting the option; more than a few have blasted away at the absence of it…
I found this at:http://www.mrexcel.com/forum/excel-...You will need to modify it to use cell references that match your worksheet.[A1:A5] refers to the cells with the Drop Downs[E:E] refers to the column that contains the Source for the Drop Downs. The code assumes that the Source column is as wideRead more
You will need to modify it to use cell references that match your worksheet.
[A1:A5] refers to the cells with the Drop Downs [E:E] refers to the column that contains the Source for the Drop Downs. The code assumes that the Source column is as wide as the data in those cells.
Right-click the sheet tab for the sheet you want this to happen in and chose View code. Paste the following code into the pane that opens, then modify the cell references.
Then go back into the sheet, select a drop down and see what happens.
Note: The workbook will need to be saved as an xlsm or xlsb file and macros will need to be enabled on the user’s machine in order for this work.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myShp As Shape, Drp As Single
On Error Resume Next
'cells holding drop downs
If Intersect(Target, [A1:A5]) Is Nothing Then Exit Sub
If Target.Validation.Type = xlValidateList Then
Set myShp = ActiveSheet.Shapes("Drop Down 1")
Drp = myShp.Width - Target.Width
'Column holding list, sized appropriately
myShp.Width = [E:E].Width
myShp.Left = Target.Left - myShp.Width / 2 + Drp * 2
End If
Set myShp = Nothing
End Sub
Solved Can’t Delete Desktop Icons Without Admin Permission
For anyone interested, it turns out that, in my case at least, the solution was "don't use Windows Easy Transfer". I had done a lot of customizing of my old platform, involving a lot of editing of permissions. WET doesn't transfer permissions and only part of those customizations, in such a way thatRead more
Solved How Do I Remove Trailing Zeroes in Excel 2010?
There are multiple ways to remove 2 trailing zeros.It depends on whether you want to leave the new values in the original column or move them elsewhere.To leave them in the same column, follow these steps:1 - Select an empty cell and enter 100 2 - Copy the Cell3 - Select your original values4 - RighRead more
It depends on whether you want to leave the new values in the original column or move them elsewhere.
To leave them in the same column, follow these steps:
1 – Select an empty cell and enter 100
2 – Copy the Cell
3 – Select your original values
4 – Right Click, choose Paste Special
5 – Check the Divide box
6 – Click OK
To have them end up someplace else, any of these methods, as well as many others, will work:
Divide by 100:
=A1/100
Use the LEFT function. Since LEFT returns a text value, multiply the result by 1 to turn it back into a number if required.
If the original value will always be 6 digits, extract the first 4:
=LEFT(A1,4)*1
If the original value will vary in length, return just the digits to the LEFT of the last 2:
=LEFT(A1,LEN(A1)-2)*1
After performing any of the “new location” methods described above, you can replace the original values as follows:
1 – Select the new values
2 – Copy
3 – Select the original values
4 – Right-click, choose Paste Special
5 – Check the box next to Values
6 – Click OK
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Solved What is Maximum Distance For Smart TV From Wifi Router
A 25 foot range could be correct with less capable wireless routers. The best way to test this is to move the router closer to the television if possible. Moving it only a few feet can make all the difference. A range extender is an option but as pointed out already it will affect your connection spRead more
A range extender is an option but as pointed out already it will affect your connection speed considerably so probably not ideal.
I myself use an Ethernet Over Power (EOP) solution for this very reason. I get decent enough speed that I can send Bluray quality information through my homes electrical wiring to any room in the house without issue. I currently have three separate rooms in the house accessing my router at decent speeds.
Something like this would be ideal:
http://m.newegg.com/Product/index?i…
You can get these that will give you 500 and even 600 Mbps speeds if you need it.
Solved How To Convert My Wireless Subwoofer To Wired
Yeah, this question has come up before several times, there is no simple answer. Unless you are good with a soldering iron and can read electronic schematics, I would leave it alone.
Unless you are good with a soldering iron and can read electronic schematics, I would leave it alone.
Solved Convert Macro Enabled Workbook To Normal Excel Workbook
In an earlier thread you were asking for help with pasting data into visible cells. In this thread you say "I just used some macros in my spreadsheet to paste data in visible cells."Does that mean that your earlier issue has been solved?As far as this particular question, you can either remove the mRead more
Does that mean that your earlier issue has been solved?
As far as this particular question, you can either remove the macros and save the file as a .xlsx or save the file as a .xls file which will retain the macros but not be seen as a .xlsm file. Whether the accepting application will know that that the macros are in the file is something you will have to test.
Removing the macros and saving it an .xlsx file should solve both issues: acceptance by the other app and prevention of further changes because the macro no longer exists.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
Solved Sudden High Cpu Usage 90-100%
Your 12Volt reading is fine in your BIOS at idle and it is a quality power supply. Your temps are good. Your internal GPU is 0.000 I assume because it is disabled due to your graphics card being your primary graphics. I do not see any special reason for the crashing but it does appear to be hardwareRead more
(computer off and unplugged, ground yourself of any possible static charge)
Clean the contacts on the memory with a soft pencil eraser, then pop them in and out of the sockets 4 or 5 times to burnish the sockets.
Remove and reseat all connectors 2 or 3 times each including the modular ones on the power supply to rub them clean.
Run Memtest86 to test memory, run through all tests at least once.
Run your SSD management software to be sure it shows no issues.
You can run it for a while in Safe Mode or off a Live Linux disk (not install) to see if you get the crash which may confirm it is hardware related.
Software related:
Run Task Manager and under the Processes Tab identify the program or process that is using a lot of CPU. If you are not sure what it is, Google it. If it is not yours, not a necessary part of the system, you may want to uninstall it. If it is a program that you use but not continuously, go into its settings and uncheck “Start With Windows”, restart the machine and see if it makes any difference. You can also run CCleaner and use its Start Up feature to manage your start up programs. Please note that running the CPU at 100% for a reason is not bad and should not cause a crash unless it overheats or becomes starved for current.
CPU current related (Increasing the voltage slightly will lessen demand for current):
If the CPU is reaching a state that is unstable under full load then it may help if you manually increase the VCore voltage by a very small amount (0.01 or 0.02) and see if it makes any difference. Here is something that may help you be more comfortable adjusting your VCore (CPU voltage):
http://www.tomshardware.com/answers…
Check Temps after adjusting voltage but a small increase should not effect it significantly.
You have to be a little bit crazy to keep you from going insane.
message edited by Fingers
Solved Flatbed Scanner Model 2400cu+ Driver Free Download
trvlr & shammahSelect: Windows 7 Driver Scanner 2400U updated on 28/03/2012 Last one on the list, seems to work.MIKEhttp://www.skeptic.com/
Select:
Windows 7 Driver Scanner 2400U updated on 28/03/2012
Last one on the list, seems to work.
MIKE
http://www.skeptic.com/
Solved Word Found Unreadable Content – Message Appears For Every Si
Sounds like normal.dot is corrupt. Just rename it to something else, and Word will recreate it the next time it opens.Also look here: http://www.askmefast.com/HiMy_broth...
Also look here: http://www.askmefast.com/HiMy_broth…
Solved Hide The Text in MS Outlook 2010
From the brief look-see/research I di on this I got the impression that it might have been viable with earlier versions of Outlook; even if one had to create/use a macro (as in one of the above links); or used an add-in item... But with 2010 version if appears that M$ (as per for most companies) decRead more
It seems that in pre 2010 versions of Outlook M$ Word was the editor in full; whereas with 2010 and later there is some form of link with M$ Word but not as was with earlier Outlook.
Incidentally you’re not alone in wanting the option; more than a few have blasted away at the absence of it…
Solved How To Change The Width of a Dropdown List in Excel
I found this at:http://www.mrexcel.com/forum/excel-...You will need to modify it to use cell references that match your worksheet.[A1:A5] refers to the cells with the Drop Downs[E:E] refers to the column that contains the Source for the Drop Downs. The code assumes that the Source column is as wideRead more
http://www.mrexcel.com/forum/excel-…
You will need to modify it to use cell references that match your worksheet.
[A1:A5] refers to the cells with the Drop Downs
[E:E] refers to the column that contains the Source for the Drop Downs. The code assumes that the Source column is as wide as the data in those cells.
Right-click the sheet tab for the sheet you want this to happen in and chose View code.
Paste the following code into the pane that opens, then modify the cell references.
Then go back into the sheet, select a drop down and see what happens.
Note: The workbook will need to be saved as an xlsm or xlsb file and macros will need to be enabled on the user’s machine in order for this work.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim myShp As Shape, Drp As Single On Error Resume Next 'cells holding drop downs If Intersect(Target, [A1:A5]) Is Nothing Then Exit Sub If Target.Validation.Type = xlValidateList Then Set myShp = ActiveSheet.Shapes("Drop Down 1") Drp = myShp.Width - Target.Width 'Column holding list, sized appropriately myShp.Width = [E:E].Width myShp.Left = Target.Left - myShp.Width / 2 + Drp * 2 End If Set myShp = Nothing End SubClick Here Before Posting Data or VBA Code —> How To Post Data or Code.