Excel formatting (.xls/.xlsx files)
SurePrep tab
In addition to the Excel functions available in the
SurePrep
tab, there are a number of additional features available in the Home
, Insert
, Page Layout
, Formulas
, Review
, and View
tab. However, not all features are available in SPbinder. Native Ability
Open in Excel
: You can select Open in Excel
, to open your file in Excel. You can make changes to the current document from there then save the current document (via File
, then Save
) when you are done. Don’t use the Save As...
option to save as a new copy at a different location.note
Saving the Excel document to a new location (via Save As...) won’t load the changes into SPbinder when you
Reload Excel
. Use File
, then Save
to save the current copy.Reload Excel
: To reload the Excel from a saved location, select Reload Excel
and select the file to reload.Related Content
-
Excel limitations in SPbinder
Format:
Article
