quinta-feira, 28 de março de 2013

Office Excel/Word-does not allow changing the Macro security level



The problem:
You try to change the Office Macro Settings in Excel or Word 2003 and can't-even with a local administrator account.
Not permitgonechange the Macro security level in the menu Tools, Macro, security.


See how to solve this problem:

1. open the Windows registry (REGEDIT): click Start, Run and type: "regedit"
2. navigate to the keyMicrosoft\Office\11.0\Excel\ HKEY_LOCAL_MACHINE\Software\ "Security" (if the problem is in the Word change "Excel" for "Word")
3. delete the folder "Security"

4. close regedit
5. open Word or Excel and change the macro security option

Done that,the problem will be solved.

Clicking Window.thethese passthe,a new key will be created:"Microsoft\Office\11.0\Excel\HKEY_CURRENT_USER\Software\ Security" (or an equivalent Word)and the "Level" value can be set between 1 and hexadecimal 4:0 pm, where 1 is "low" and 4 is "very high". By às Nenhum comentário: Marcadores: , , , , ,

System error 8H80040111 ( -2147221231)

The problem:
You are getting the followingerror messagein Office (??): "System error 8H80040111 ( -2147221231). ClassFactory cannot supply requested class "



To work around this problem, simply delete the file pipc32.xll (the IP System) in the Office installation folder.
By às Nenhum comentário: Marcadores: , , ,

Buffer Overrun detected! in Word 2003

The problem:
The files *. c q EU are open with MS Word 2003 andare displaying the following message errthe:
"Error:" Buffer Overrun detected!in MS Word 2003 ""(has this exclamation even there?)

To resolve this problem,follow the stepsbelow:

1. log into associate mámachine with an account that has privileges of administrator;
2. navigate to the folder%programfiles%\Arquivos comuns\Microsoft Shared\PROOF\ and renomSIS file "" to "Mssp3es.OLD.dll" Mssp3es.dll

 Source: http://support.microsoft.com/kb/950009/en-us By às Nenhum comentário: Marcadores: , , , ,

The value entered is not valid


To insert a text in a given cell in the Excel error appears: "the value entered is not valid. Another user has restricted values that can be entered into this cell. "

 Solution:
1. Select the cell in which the user wants to perform change;
2. Click on the Tools menu, data
3. Ns SETTINGS tabSelect the VALIDATION option, and select the option ANY VALUE in the menu to ENABLE
4. click OK and test.
By às Nenhum comentário: Marcadores: , , , ,

Office file validation has detected a problem while trying to open the file

When you try to open a file from Word, Excel, PowerPoint, or Publisher 97 to 2003, and this file fails Office file validation, the following warning is displayed:
"The office file validation has detected a problem while trying to open the file. It may be dangerous to open it. "

 This error occurs because the Add Validation In is installed on your machine and for some mutivo he did not validate the file that you are trying to open.

 Add Validation In,
Office file validation (OFV) is a security feature that was introduced in Microsoft Office 2010 and that checks whether a specific binary file meets the expectations of the application. Office file validation can help prevent attacks by unknown binary file formats file formats from Microsoft Office 97-2003.

A quick way to solve this problem and removing the Add Validation In

1. Click Start
2. click Control Panel
3. on the Control Panel Add/Remove Programs cliqcar
4. Select Add Validation In and then click on Uninstall
Other problem that you may experience when you use the Add Validation In:
  • Files created in Microsoft Excel 2.0, 3.0 or Microsoft Excel Microsoft Excel 4.0 fail validation when you use Office file validation in Office 2003.
  • The Solver.xla file failed validation when you use Office file validation in Office 2003.
  • When you paste a lot of graphics or data points in an Office 2003 document, the paste function can take a long time to be completed while the Office file validation attempts to validate the new data.
  • Open files on a network that has many graphics or data points takes longer in Office 2003.

Another way to solve without having to uninstall Validation Add In:

Solution for Office 2010

You can manually set the registry entries by using the following values:
Value: DisableEditFromPV
Type: REG_DWORD
Default value: 0
Description: When the Office file validation failed
0 = enable editing in protected view.
1 = Disable editing in protected view.
Add the DisableEditFromPV REG_DWORD for any or all of the following registry subkeys to disable editing in protected view in Office 2010:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\PowerPoint\Security\FileValidation
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security\FileValidation

Solution for Office 2007 and Office 2003

You can manually set the registry entries by using the following values:
Value: InvalidFileUIOptions
Type: REG_DWORD
Default value: 0
Description: When the Office file validation failed
0 = notify user about file failed. Offer the user the option to download the file or not
1 = notify user about file failed. No option to download the file.
For the 2007 Microsoft Office system
Add InvalidFileUIOptions REG_DWORD for any or all of the following registry subkeys for Office file validation in Microsoft Office 2007 system:
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\Word\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\12.0\PowerPoint\Security\FileValidation
For Office 2003
Add InvalidFileUIOptions REG_DWORD to any or all of the registry subkeys for Office file validation in Office 2003:
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\Excel\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\Word\Security\FileValidation
HKEY_CURRENT_USER\Software \Microsoft\Office\11.0\PowerPoint\Security\FileValidation



Source: http://support.microsoft.com/kb/2501584/pt-br
By às Nenhum comentário: Marcadores: , , , , , , ,

Unable to Load Hlink.dll

Hi
If you are having problem to view a PowerPoint file, preview is displayed the following error message: "unable to Load Hlink.dll"
"Hlink.dll Can't Be Loaded" or "PowerPoint Failed to Load Hlink.dll"
This solution can also be applied to the following errors:

"PowerPoint couldn't create a hyperlink with ^ 0."

"PowerPoint failed to Load Hlink.dll"
This error occurs when there is a problem in the file "C:\windows\system32\hlink.dll" and it is necessary to replace this file.

Solutionfast:

1. Open session with administrator privileges.
2. Copy the hlink.dl_ file from the Windows XP CD that is in the directory "i386\pt\" to "c:\windows\system32".
3. Open CMD and type the following commands:
3.1. "del hlink.dll"
3.2. "expand hlink.dl_ hlink.dll"
3.3. "regsvr32/s hlink.dll"
Comprehensive solution:
1. close all open files and all running programs.
2. click Start, point to Find and then click files or folders.
3. in the box With the name, type hlink.dll.
4. in the Search, make sure that drive C is selected, and then click find now.
5. If you find the Hlink.dll file, right-click the file, and then click Rename.
6. Change file name "Hlink.dll" to "Hlink.old".
7. Insert the Microsoft Office XP CD in the CD-ROM drive or DVD-ROM drive.
8. click Start and then click Run.
9. in the Rundialog box, type the following command line where drive is the drive letter of your CD-ROM or DVD-ROM drive:
extract drive: IENT_1.cab/L \IE5\PT\IENT_S1.cab c:\windows\desktop andClick OK.
10. click Start and then click Run.
11. To extract the Hlink.dll file, in the Rundialog box, type the following command line:
extract c:\ \desktop\IENT_1.cab hlink.dll/Lwindowswindows\system32 c:\ Click OK.
12. click Start and then click Run.
13. to register the Hlink.dll file manually on the 32-bit operating system, in the Rundialog box, type the following command line:
c:\windows/s \system32\regsvr32windows\system32\hlink.dll c:\
Click on OK.

Source: http://support.microsoft.com/kb/813726
By às Nenhum comentário: Marcadores: , , ,

Windows 7 folders

Do you know where the main folders used by users in Windows 7 are?

Users' temporary files, Internet files, Start menu shortcuts, Taskbar shortcuts and others...

Know some of the important directories in Windows 7

  • Folder of shortcuts pinned to taskbar - Quick Launch

%UserProfile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar

 It is in the folder above that are all the icons that you add to your Taskbar

  • Shortcuts folder pinned to the Start menu

%UserProfile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\StartMenu

  • DESKTOP folder path of ALL USERS (All Users) in Windows 7

This folder is hidden by default. You must enable the "Show hidden files, folders and drives" option to view this folder:

1. Open Windows Explorer (Windows flag key + E) click on the Tools menu, Folder Options and check the option "Show hidden files, folders and drives";
2- Access the path: C:\Users\Public\Desktop.

  • Folder Path "Start Menu" User Profile

%USERPROFILE%\AppData\Roaming\Microsoft\Windows\Start Menu

  • All Users Start Menu Path in Windows 7

C:\ProgramData\Microsoft\Windows\Start Menu\Programs

  • Internet Explorer Temporary Files Folder "Temporary Internet Files" User Profile


This is the path of the current user (user logged into the machine)
%UserProfile%\AppData\Local\Microsoft\Windows\Temporary Internet Files

  • Temporary Files in User Profile

%UserProfile%\AppData\Local\Temp
By às Nenhum comentário: Marcadores: , , ,