Question about PC Desktops

2 Answers

Excel 2007 (Exporting info from MRI)

Hi. I am trying to export accounting information from MRI to Excel 2007, but am getting a 'Run Time Error '6' overflow' Do you have any solutions or settings that I should have on my computer? There were no problems exporting from MRI to Excel 2003.

Thanks!

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

In excel options, under trust center settings, macro settings, check the box that says 'trust access to the VBA project object model'.

Posted on Jan 19, 2015

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sergeant:

    An expert that hasĀ over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 329 Answers

I suggest that you should you Office 2003 much better. office 2007 has a very hard time to use, even if its user friendly. but i dont waste time just to configure such DELICATE Problems like office 2007. if theres any problem just contact me sir/mam. thanks!

Posted on Mar 28, 2008

  • robertdour Jan 26, 2011

    My accounting staff came up wih this..

    Click Excel options:



    Click on Trust Center

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How Repair of Excel file?


If there was such problem, the simplest decision is described here:
http://www.excel.repair/ - Excel Repair Kit. A Microsoft Excel repair tool for corrupted Excel spreadsheets. Program open, read and save data from damaged Excel files.
If at you it didn't turn out to solve a problem, it is possible to try to solve it otherwise:
1. Click the Microsoft Office Button Office button image, and then click Open.
2. In the Open dialog box, select the corrupted workbook that you want to open.
3. Click the arrow next to the Open button, and then click Open and Repair.
4. Do one of the following:
3. To recover as much of the workbook data as possible, click Repair.
(a) To recover as much of the workbook data as possible, click Repair.
(b) To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Oct 17, 2015 | PC Desktops

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | PC Desktops

Tip

How to Backup Your Outlook Contacts to Excel File?


Microsoft's Outlook is integrated into Microsoft Office 2000, 2002, 2008 and Microsoft Exchange Server. Outlook is complete e-mail manager by which you e-mail, calendaring, and contact management. Outlook enables you to filter and organize e-mail messages, integrate and manage e-mail from multiple e-mail accounts, personal and group calendars, contacts, folders, and tasks.
Using Import and Export feature in Outlook, you can create the full backup of outlook contacts. Because without backup yon can lose your e-mail accounts data any time due to virus, power failure and hard disk problem.
Follow the given steps to export your outlook contacts to Excel file:
Click on Start button, go to Program then click on Microsoft Outlook to export the contacts.


Now go to File menu and click on Import and Export option. Choose Export to a file as show in the below figure then click Next.
export-computerfreetips.gif Now on next dialog box, choose Microsoft Excel and click Next.
export-computerfreetips1.gif Select the Contacts Folder you want to backup to Excel file as shown below then click Next.
select-computerfreetips.gif Choose a name and location where to save the Excel file by clicking Browse button, then click Next.
file-computerfreetips.gif Click Finish to start the back up procedure which may take little time depending on how many contacts you have.

on Jan 29, 2010 | PC Desktops

1 Answer

Error msg.


hi: first at all what program are you try to load? do you try to do a new install of os ?please be a litter more specific, but usually that error is due a application that is not stared correct, , so for give you a better solution please post a litter bit more of information about your problem. best regards italocub.

Jun 12, 2009 | E-Machines eMachines Desktop PC

1 Answer

Speed of excel is v slow


you are using microsoft office 2007 version. it need 1.5 GB ram. how much ram in your system?

Jan 26, 2009 | Compaq Presario 5000 PC Desktop

2 Answers

Hello, My company uses Outlook Web Acess connected to Microsoft Exchange. My personal email is AOL...Im trying to export a group of e-mails from AOL to Outlook WA email? AOL Tech support cannot...


HI Azkinney,

I can help you it's not pretty but it works without downloading or buying any programs.

1- create an email with your aol interface
2- open your address book and add everyone
3- don't send the email but select the addresses you have in your "TO" field of the email you created
4- copy the selected addresses to a word processing program like word pad
5- save the new document as a .txt file
6- open this document with Microsoft excel
7- export the document with a CSV file format
8- outlook can import CSV files into the address book

You know its a lot of steps but its the simplest way I have found since AOL hates their customers using other emails and will be as much help as a canker sore on your nose.

I hope this helped. Please don't forget to rate the answer it helps me with my solutions.

Nov 13, 2008 | PC Desktops

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Nov 06, 2008 | PC Desktops

1 Answer

I have installed Microsoft Office Home and Student 2007 but, each time I try to open Word or Excel, I get the Windows Installer window which asks me to wait while it configures Office. The Word 2007 Window...


Is the account you use an administrator account? The reason I ask is I have seen similar bahavior on office 2000 where the user account does not have the rights to set up Word properly. If it is limited user, temporarily make the account administrator, load word, and then close it. then put the account back limited user if you wish, it should not need admin again. Microsoft never test their products on limited user accounts....

Aug 20, 2008 | PC Desktops

4 Answers

How can i export tally data to excel format?


Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. excelexport.jpgIf you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

excelexport2.jpgThe special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | PC Desktops

Not finding what you are looking for?
PC Desktops Logo

Related Topics:

1,201 people viewed this question

Ask a Question

Usually answered in minutes!

Top PC Desktops Experts

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Are you a PC Desktop Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...