Triva isn't available right now.
Check out the support page for our phone number and hours
Legal
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
Questions? We are here to help
Tax & Accounting
-
Top products for corporations
-
Top products for accounting firms
Recommended Products
-
CoCounsel Tax, Audit, Accounting
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Excel limitations in SPbinder
Excel feature in SPbinder has the following limitations:
- Cell comments and form controls (such as buttons, checkboxes, list boxes) won’t be read from Excel files.
- Pivot tables are not supported (that is, GETPIVOTDATA).
- Reading and writing of shapes are limited to a few shapes. Unsupported shapes won’t appear in the SPbinder.
- Excel files with hidden sheets are not supported. Delete the hidden sheets from the Excel files before uploading the files, make the hidden sheets visible before uploading the files, or don’t upload those files.
- Certain fields may show #NAME, #REF, #N/A value in SPbinder.
- SPbinder doesn’t support hidden rows and columns. Unhide any cells before uploading the Excel.
Data shows the value as #NAME, #REF, #N/A
Some data in the Excel file doesn’t show up properly and the value shows as #NAME,#REF, or #N/A. The issue could also be caused if an Excel function is not supported.
Follow these steps to possibly resolve the issue:
Option 1 - Rename Client ID folder
First close the binder, then go to the
SurePrep Download Folder
path on your machine/network. note
If you don't know where
SurePrep Download Folder
is located then go to Admin > ACCOUNT SETUP > Download Files Setup
. The SurePrep Download Folder
path will appear on the bottom.
Next, go to the folder that the binder's tax year is associated with (for example, 2019, 2020, 2021).
Go to
SPDocument Files
.
Locate the folder with the same Client ID as the binder, right-click, then select
Rename
. Give the folder another name to force SPbinder to download a new copy of the binder.
Open the binder again to see if the issue resolved.
Option 2
Open the Excel in the native application.
Open the binder, on the Document Viewer, select the
SurePrep
tab.Select
Open in Excel
.Check if the values appear properly or not.
If the values appear properly in the Excel file, save the excel and reload in the binder.
If the value doesn’t appear properly, then contact SurePrep Support to resolve this issue.
Hidden spreadsheets in Excel
Excel files with hidden spreadsheets are not supported. When submitting an Excel file, delete the hidden sheets from the Excel files before uploading the files, make the hidden sheets visible before uploading the files, or don’t upload those files.
If you opened an Excel file from SPbinder and then hide the Excel spreadsheet, it will disappear from the
Thumbnail
and INDEX TREE
. Re-opening the Excel and then unhiding the sheet won’t restore the sheet.Solution: Unhide and re-import the Excel spreadsheet or copy that information to a new excel spreadsheet and import the new spreadsheet.
This article applies to:
- Product: SurePrep
- Sub Product: SPbinder
Related content
-
Excel formatting (.xls/.xlsx files)
Format:
Article,
1 min read