DicasQueFunfa

Análise do problema A usuária tinha dois arquivos do Excel; Exe: arquivo_1 e arquivo_2 Ao abrir os dois arquivos ao mesmo tempo no Excel 2003/2007/2010, no momento de desfazer alguma alteração no arquivo_1 ou arquivo_2, a alteração acontecia nos dois arquivos; isso porque o Excel abria os dois arquivos em uma mesma instância (na mesma janela) e isso é padrão do Excel em todas as versões. Para contornar esse situação, foi feito uma configuração do registro do windows para fazer o excel abrir cada arquivo em estancia separadas, para cada arquivo, é aberto uma janela do Excel.exe Vide a solução abaixo: Esse solução se aplica em todas as versões do Microsoft Excel. Solução para o Microsoft Excel 2003 1. Abra o Bloco de Notas e colar o  código  abaixo: Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open] @ = "Abierto (O &)" [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command] @ = "\"C:\\Program Files (x86)\\Microsoft

Se você estiver com problemas para abri arquivos com a extensão ".REPORT" no MS Excel, vide a possível solução: Solução pra abri arquivos ".REPORT" no Microsoft Excel Cenário Você fez o download de determinado arquivo com a extensão " .REPORT" utilizado algum cliente de ftp (nesse exemplo o FileZilla ), depois tentou abri esse arquivo no Excel e não teve sucesso. Análise do problema Isso ocorre porque esse arquivo está corrompendo no momento da transferência.  E por que está corrompendo? Porque no FileZilla está  configurado o  tipo de transferência como padrão.  O problema pode ser resolvido alterando o modo de  transferência   para “ ASCII ”.  Vide o passo a passo abaixo: Solução 1.       Instalar e configurar o FileZilla - Download FileZilla ; 2.       Abrir o FileZilla e navegar até a aba “ Editar ” > “ Configurações ”; 3.       Navegar para “ Transferência ” > “Tipo de arquivo”; 4.       Na opção “ Tipo de transferência pa

The problem We can see that the user was with problem to run a macro in an Excel 2010 file, which used a SOLVER add-in. Whenever the user ran the macro, was displayed the following error message: Error Message in text: “--------------------------- Microsoft Visual Basic for Applications --------------------------- Compilation error: Is unable to find project or library --------------------------- OK Help ---------------------------“ Error Message in image: Talking to the user we discover that the file that was showing the error was created in a different version of Microsoft Excel 2010. The file was created in Excel 2003. Solution Analyzing the structure of the file and the SOLVER references we have found that the reference to the solver was with the status missing: SOLVER and the appointment to the Office 2003 installation folder. It was there that we found the problem. See the step by step to solve the problem m

The problem : We can see that the user was having problem to run a macro in a Microsoft Excel 2003 file, which used some of the references to the Progresses. Whenever the user ran the macro, was displayed the following error message: Error message text: “--------------------------- Microsoft Visual Basic for Applications --------------------------- RUN TIME ERROR ' -2147312566 (80029c4a) Unable to move the focus to the control because it is invisible, not enabled, or is of type that does not accept the focus. --------------------------- Order Debug Help ---------------------------“ Error message in image: Solution Analyzing the file structure and references of the Progresses we find that the reference to the " Microsoft Windows Common Controls 6.0 (SP6) " was with the status " MISSING ". See the step by step to solve the problem mentioned in the above image: 1. click CLOSE in the error message and close completely your Excel

Hi Here's how to troubleshoot running add-ins created in versions earlier than Microsoft Excel 2007. Installing the Excel 207 are not enabled add-ins to VBA projects. With this, when you run a spreadsheet that has VBA Tools, such as COMBO BOX-COMMAND BUTTON, you receive error messages due to lack of management component of Visual Basic Applications. To resolve the problem, follow the step below: 1. click on Start Menu- Settings - Control Panel - Add and remove programs . 2. Select the Excel 2007 and click Modify . 3. in the installation options, select the option to add or remove features and select components of project management in VBA. 4. click Install then Next and wait for the end. 5. Log on the user account and access the Microsoft Excel 2007. 6. click on the Office Button in the upper-left corner of the screen and select " Excel Options " will open a screen of advanced settings. 7. Select the option " Add-ins " and then select the option to insta

Problem to install Office 2007. In the process of installing Office 2007 you are faced with an error message when you copy the file RBULDR. CAB. In then the installation is finalized. See the step by step to solve this problem: 1. Insert the Office CD and open the folder 2. in the ROSEBUD. En copy the file " fp4autl.dll " to the installation folder that is in the path:%COMMONPROGRAMFILES%\microsoft shared\web server extensions\40\bin\ Note: If there is another file to replace the current file 3. Navigate again to the ROSEBUD. En Office 2007 CD and run the file ROSEBUDMUI. THE MSI. Following this step your problem will be solved.