Saturday, September 28, 2013

yogi_Adjust Sumproduct Formula Used In Google Spreadsheet So That It Will Continue To Work When Spreadsheet Is Downloaded Into Excel

                                          Google Spreadsheet   Post  #1379
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 28, 2013
user Pat Gilbert (http://productforums.google.com/forum/?zx=kq47eb7b00d7#!mydiscussions/docs/weoTzEAnypE)
How to save a google spreadsheet as excel with Formulas
Is there a way to retain formulas in a google spreadsheet that is saved as xlsx? I want to save my completed speadsheet to my desktop and remove it from Google Drive....
I'm using Win 8 with Mozilla Waterfox browser.

---
Yogi,
Her is the link to the sample spreadsheet,

https://docs.google.com/spreadsheet/ccc?key=0ArUt_HBqvxZkdFRmcm95cWRtRVRRdGpFTFpKaWIzUVE&usp=sharing

Cheers
Pat

-------------------------------------------------------------------------------------------------------------------------------------------