Office-related FAQ's
Excel: How to get out of a Print Preview of an Office section? |
---|
In case you have activated the Print Preview via the File Menu of the Office section, the preview window is shown in the section tab. Please press the ESC key to return to the normal Office menu. |
How to print an Office section in E-Notebook? |
---|
There are two different approaches for printing experimental data stored in Office sections.
You can use the ‘File’ menu of the respective Office section which is accessible in each section (see screenshot).
You can print the respective Office section following the standard approach which is accessible for all available sections in any experiment.
|
Word: "Sorry, Removing Word macros failed. Please make sure..." warning appears when opening a Word file in ELN |
---|
If you click OK you can proceed without any problems. To avoid this error follow this procedure: 1. Open MS Word (make sure no Word file is opened in ELN) |
Saving of an experiment fails due to large Office documents |
---|
Sometimes, you observe the following error when trying to save a large Office document: Sorry, while saving, …, the total size for documents in this collection is greater (…) than 21 MB.
Possible solutions: |
PowerPoint 2007: Compatibility Checker Warning Issued |
---|
Sometimes, users get a Compatibility Checker Window when they are trying to save a PowerPoint 2007 document in ELN. Unfortunately, the Compatibility Checker window does not seem to be accessible with the mouse.
Possible solutions: In order to suppress the warning message completely, you can opt to change the Regional Settings on your PC to English/US. Please contact your local IT support for further support. This problem has been signaled to the vendor of the ELN software support and is been worked on with high priority. We hope to receive an update of the ELN software soon. |
How to avoid Share Violation Error in Excel (Office 2007 - 2010) |
---|
Some people experience that Excel 2007 or Excel 2010 gives a specific ‘Share Violation Error’ after copy/paste actions between Excel sheets which ends up in an endless loop. This loop can only be stopped by force-quitting ELN. Unfortunately, it seems impossible to reproduce the error. Remedy: Please change your Regional Settings to English/US. This can be done as non-admin user. For Windows XP: The country or region setting in Windows, referred to as location, indicates the country or region that you are in. Some software programs and services provide you with local information, such as news and weather, based on this setting.
For Windows Vista and Windows 7: |
How to display inserted Images in Word immediately? |
---|
Some E-Notebook users on the Citrix platform experience that images are not shown instantaneously when they open an Word section type. If you switch to the ‘Full Screen Reading’ Document View or print out the Word file, the image is displayed or printed as expected. Remedy: The display issues of certain images in Word seem to be related to the standard settings of the text wrapping for images.
|
Excel 2007: How to get out of ‘Attempt to Access Invalid Address’ Error? |
---|
Some E-Notebook users get the following error when they work with the Excel standalone version and Excel in
E-Notebook at the same time.
Remedy: Error : "Sorry , Attempt to access invalid address". This issue is mostly observed when the Temp Location is full or if you have issues in the Temp or tmp Environment variable configuration on the machine. Suggestion:
|
Excel 2007: How to copy paste from one Excel section to another? |
---|
Copy/Pasting from one sheet of a Excel section (tab) to another Excel tab within E-Notebook while preserving the formatting can be achieved via a temporary Excel file opened in a standalone Excel application. Please try the following steps (the order of switching between ELN and Excel is important!):
|
Word: How to display hidden textboxes |
---|
Case Since yesterday, I have a problem with viewing of my text-boxes on Microsoft Word documents in ELN (I use the text boxes to label my gel images). If I change the view from print layout to full screen reading then I am able to view the textboxes again and the correct positions. Remedy Word 2007: click the Office button and choose Word Options. 2. Click Advanced at the left side of the dialog box.
|
Excel crashes in E-Notebook when adding CUSTOM error bars |
---|
Case Excel 2010 in E-Notebook crashes reproducibly when CUSTOM error bars are added to an Excel section.
Work-around |
Word: "Sorry, Removing Word marcos failed." error when importing a Word file |
---|
Case When you want to import a .doc file in ELN, you can get an error, even if this file is exported from ELN. Remedy 1 |
Embedded Office applications seems zoomed in (large fonts) in ELN - client installation (Windows 8.1 and 10) |
---|
Case When you open a Word or Excel file in your ELN client software things seems very large and unreadable for a small screen.
|
PowerPoint 2013: copy/paste one slide to another PowerPoint file in ELN gives error |
---|
Case When you copy a slide from a PowerPoint file (inside or outside ELN) and paste this (using right-click) in another PowerPoint file in ELN, you get an error and the software blocks. |
"Sorry, while displaying the command bars, could not find..." error when creating a Word or Excel file |
---|
More information about this error can be found on this PerkinElmer Support page; |