Does anyone know where to find the documentation on the latest Essbase VBA commands for Excel. I currently have a book from Arbor - Essbase 4.0, I think. I thought it might in online help?

The best way is to install the Excel add-in and then check the Spreadsheet toolkit documentation

You have it here as well http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_client/spreadsheet_toolkit.html

I found that you can also get there by going to Essbase help when in Excel.

I am hoping this is the case with my panning hand all of a sudden disappearing in Excel 2010, I m in compatibility mode cuz I open excel sheet from 2003-2007 made on my XP Professional Ofc 2007. Can someone guide me through on how to retrieve the essbase VBA add in that is somehow now missing?

I wasn't sure what Macro was so I disabled it. I create large xl files & the panning hand was what helped me maneuver around without issue. I also did copy & paste from one Excel 2007 to 2010 sheet would this be factor that contributed to panning hand missing?

Please advise.
Standing by.
Thanks

I'm not clear on what the issue is.

Your Smart View ribbon disappeared from Excel?

I did customize my ribbon & added smart views, objects, charts etc. Just as processes of elimination thinking that could of been why panning hand is now missing. I clicked reset in customize ribbon window, hoping to reset ribbon to default. Maybe panning would reappear. Didn't work. I also uninstalled mouse & re-installed it, no change. Spoke to MS tech he uninstalled & re-install excel.....still the same, no change.
The panning hand located on the top of the vertical scroll. I use it so much in excel so I know its got to be retrievable just not sure how. & Why it disappeared in the first place.

Does the VBA properties have anything to do with panning hand missing? To see VBA properties I was told (see below)
From my excel worksheet,
press Alt + F11,
Next press Ctrl+G, -------(here my VBA shows... Scro1lArea Blank)
Type in (or copy here and paste): Application.CommandBars("Cell").Reset, ----( unable to get this to do anythign)
Then press the Enter key.
Press Alt+Q to return to the worksheet,

This was to restore a mouse to it default settings, since I have not had any luck regarding panning hand I thought i'd try it, to no avail. I also didn't copy paste... Application.CommandBars("Cell").Reset, in the correct place cuz it kept giving me an error.

Sorry about typo

http://docs.oracle.com/cd/E12825_01/epm.111/esb_client/frameset.htm?spreadsheet_toolkit.html

I am missing panning hand in Excel 2010


I did customize my ribbon & added smart views, objects, charts etc. Just as processes of elimination thinking that could of been why panning hand is now missing. I clicked reset in customize ribbon window, hoping to reset ribbon to default. Maybe panning would reappear. Didn't work. I also uninstalled mouse & re-installed it, no change. Spoke to MS tech he uninstalled & re-install excel.....still the same, no change.
The panning hand located on the top of the vertical scroll. I use it so much in excel so I know its got to be retrievable just not sure how. & Why it disappeared in the first place.

Does the VBA properties have anything to do with panning hand missing? To see VBA proerties I was told (see below)
From my excel worksheet,
press Alt + F11,
Next press Ctrl+G,
Type in (or copy here and paste): Application.CommandBars("Cell").Reset,
Then press the Enter key.
Press Alt+Q to return to the worksheet,

This was to restore a mouse to it default settings, since I have not had any luck regarding panning hand I thought i'd try it, to no avail. I also didn't copy paste... Application.CommandBars("Cell").Reset, in the correct place cuz it kept giving me an error.

Will this link help me with panning hand?

Ok, I was thrown off by "Panning Hand".

I don't think this is a Smart View issue. Maybe you're in Object Select mode? I have Excel 2007, not Excel 2010, so this may not translate exactly, but try something like this:

Click "Find and Select" on the Home ribbon, then click "Select Objects" to toggle that setting back to normal.

Where on ribbon is find & select?

On mine, Excel 2007, it's the last button on the Home Ribbon, inside the "Editing" group.

It looks like it's the same in Excel 2010 per this screenshot:

http://excelhints.com/Blog/wp-content/uploads/2009/07/Excel-2010.jpg

Click Find & Select, Select Objects.

Yes I selected object now what?

I thought that might be the cause; it sounds like no.

I'm out of suggestions.

I sent you an email. Since you may know more about Macros & tool bars It's pretty extensive. & directed for Word 2002 2000 not excel but is the same concept. Should I try any other those? Are you getting email? i snipped the VBA that shows scroll area icon blank


or should I post it here?

I'm not familiar with the panning hand, but I don't think the loss of the panning hand toolbar button is related to Smart View.

There are no Hyperion VBA functions that have any relation to the panning hand.

It is located at top of vertical scroll bar on the right side of your screen....it is in an MS add- in
I don't know how to send snip to this site or I could show it to you. I think if someone knew how to maneuver thorough this link:

http://docs.oracle.com/cd/E12825_01/epm.111/esb_client/frameset.htm?spreadsheet_toolkit.html


It in the MS Add-in area...

This isn't related to Hyperion. Your link to the VBA functions for the Essbase AddIn is not related.

Google "enable disabled excel addin"

Google is really scary. I do not trust these sites. I just click on one & reading below......many issues & virus related....I can't risk it. I am still hoping Some one will help me with ORACLE link I found on a conversation on this site. On a un realted issue but ORACLE tool kit looks like it has the answer.

I guess I will hope I will have to wait to see who will click link & see if restoring or retrieving add-in for panning hand is in here.

Thanks for your time & effort it is appreciated.

Nope, the Oracle link is ABSOLUTELY NOT related to your problem.

It has nothing to do with panning hand.

Ok I guess I am SOL panning hand MIA even in compatibility mode

Thanks you very much for the effort & patience. Panning hand here 1 day & gone the next. Bummer.
Have a nice evening !

If anyone happens upon the add-in that is contributed to panning hand please email me.
using Excel 2010 but am in compatibility mode for Excel 95-95 & 2003-2007

Its is a process of elimination.