Saving workbooks

[Former Member]

What is the difference between saving a workbook to the server using the BEx tool bar and saving it to the local drive using the Excel File menu?

[Former Member · Accepted solution]

saving a workbook to the server using the BEx tool bar

That is how you do it - You can run the workbook again.

saving it to the local drive using the Excel File menu?

You are just saving it as an Excel Sheet, BEx tool bar will not be seen.

[Former Member · Accepted solution]

You are just saving it as an Excel Sheet, BEx tool bar will not be seen.

But if you want to run it from the server again, you could open the file from the File Menu and refresh it to connect it to the server.

1) What would be the appropriate way to save the workbook - server or local?

2) Are there any settings that must be set before saving to the local drive?

3) What exactly does the following settings from the 'Workbook Settings' do

-Transfer Plan Value to the Server before navigation

-Confirm Transfer of Plan Values to Server Before Navigation

-Do not Transfer Plan Values to Server Before Navigation

http://help.sap.com/saphelp_nw70/helpdata/en/54/a493f7256b43698191a2623e5a0532/content.htm

I found this but simply what each option does?

4) What are Plan Values? Do this have to do with Integrate Planning?

Thanks

[Former Member · Accepted solution]

>

> You are just saving it as an Excel Sheet, BEx tool bar will not be seen.
> 
> But if you want to run it from the server again, you could open the file from the File Menu and refresh it to connect it to the server. 
> 
> 1) What would be the appropriate way to save the workbook - server or local?
> 
> 2) Are there any settings that must be set before saving to the local drive?
> 
> 3) What exactly does the following settings from the 'Workbook Settings' do
> -Transfer Plan Value to the Server before navigation
> -Confirm Transfer of Plan Values to Server Before Navigation
> -Do not Transfer Plan Values to Server Before Navigation
> 
> http://help.sap.com/saphelp_nw70/helpdata/en/54/a493f7256b43698191a2623e5a0532/content.htm
> 
> I found this but simply what each option does?
> 
> 4) What are Plan Values? Do this have to do with Integrate Planning?
> 
> Thanks

Hi BI Question,

Did you find out answers to your questions. I'm goign thru more or less the same situation and i came across your thread. Hopefully, if you see this msg, you'll update it.

Thank you,

Imtiaz