Activecell.ServerActions

Bugzee

Guest

Posts: n/a

17th Aug 2009

Hi All,
I'm trying to draw details from an OLAP database via a pivot table using the
Activecell.serveractions statement.
The problem I'm encountering is that the code following the statement is
executing before the data table is created. The data only seem to update
after the macro crashes.

Can someone please help?

Thanks

« Disable Change-event macro | Re: Macro - Find unique value and paste with content from column with border »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ActiveCell.Value	tmarsh7407	Microsoft Excel Programming	2	26th Apr 2008 03:18 PM
Excel 2007 Range.ServerActions Property displays read-only data	SG	Microsoft Excel Programming	0	31st Jan 2008 03:33 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Microsoft Excel Misc	1	2nd Oct 2007 08:05 PM
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format	Karthik Bhat - Bangalore	Microsoft Excel Programming	1	9th May 2007 02:37 PM
activecell	slikity	Microsoft Excel Programming	7	13th Dec 2004 11:59 AM