After installing the Oracle SmartView addin in Excel 2010, the Excel application started to behave rather strange. Problem #1 When quitting the Excel application while a workbook/addin with a password protected VBProject is open (not an unusual situation), the user would be prompted from 1 to more than 100 times to enter a VBProject password. [...]
Archive for the ‘Problem Solving’ Category
OK, no magic involved in this tip. Saving a worksheet as PDF file will take some time, no matter what. You can’t do much about that, but when you are saving many worksheets as PDF files you want this process to go as quickly as possible. I was going to save around 3000 PDF files, [...]
You might have encountered this error message while trying to create a PivotTable, and scratched your head trying to figure out what is wrong with the source data you have selected. Especially if you have had no trouble creating a PivotTable before using the same or a similar data source range. Well, despite what the [...]
Some Canon printers are able to print on CDs or DVDs, where you can put a printable CD or DVD into a tray and feed it to the printer. During the printing process many users experience problems with different error messages and the result is that the CD tray is being rejected. The first trick [...]
After buying the Office 2007 version I started to experience a lot of crashes in Excel 2007, especially when closing workbooks and opening new workbooks. After each crash I found something like this in the Application Event Log on my laptop: Faulting application EXCEL.EXE, version 12.0.6331.5000, time stamp 0x48fa2869, faulting module OLEAUT32.dll, version 6.0.6001.18000…….
I have been very lucky perhaps, since I have only experienced 4 hard disk break downs after using computers for around 20 years. The first one occured only 2 days after I took a complete backup of it, so I did not loose any important stuff, and it was no need to try to rescue [...]
While working with the Hyperion Essbase Spreadsheet addin to retreive information from an accounting server, the error message “Currently, multiple reports per retrieval is not supported” started to show up, on reports that previously had worked without any problems. And other users could use the same reports to retreive data without any problems. After much [...]