If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automation Error
I have Access-to-Excel automation trying to use 7 (seven) Worksheets.
One worksheet ("DataSheet") receives the data from Access, & the other 6 are required to display 15 Charts each. All was fine w/ the using "DataSheet" & 5 Chart Worksheets, but adding the 6th Chart Worksheet & pasting in Charts which will have Cell References modified gives this... "No more new fonts may be applied in this Workbook". Apparently if I keep clicking each "instance" of this message, the Chart then is pasted & "appears" to be Working properly. Any insight welcomed. TIA - Bob |
#2
|
|||
|
|||
Automation Error
Search support.microsoft.com for the error message. One of the several
suggested links will be http://support.microsoft.com/default.aspx? scid=kb;en-us;215573 It really comes down to turning off the 'autoscale fonts' feature. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have Access-to-Excel automation trying to use 7 (seven) Worksheets. One worksheet ("DataSheet") receives the data from Access, & the other 6 are required to display 15 Charts each. All was fine w/ the using "DataSheet" & 5 Chart Worksheets, but adding the 6th Chart Worksheet & pasting in Charts which will have Cell References modified gives this... "No more new fonts may be applied in this Workbook". Apparently if I keep clicking each "instance" of this message, the Chart then is pasted & "appears" to be Working properly. Any insight welcomed. TIA - Bob |
#4
|
|||
|
|||
Automation Error
You are welcome.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Tushar - Thank you. I thought it was probably a setting. Bob |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PRB: Automation Error: Remote Procedure Call Failed | Niall Merrigan | General Discussion | 0 | September 27th, 2005 10:17 AM |
Reserved Error - 1104 - Works in 97 not in XP? | beveritt | General Discussion | 0 | August 25th, 2005 05:07 PM |
record is deleted error | Ian Burton | General Discussion | 1 | June 2nd, 2005 05:09 PM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |