<\/span><\/h2>\n\n\n\nThere are many routes out of which the user can pick one to fix the Sage 50 Canada export report in Excel error. Each of these solutions is very easy to follow and even if a user is not tech-savvy they do not need to worry as the steps mentioned below are very straightforward and the user will not face any difficulty while attempting to fix Sage 50 Canada export report in Excel error.<\/p>\n\n\n\n
Following are the solutions out of which the user may pick one and follow to fix Sage 50 Canada export report in Excel error.<\/p>\n\n\n\n
<\/span>Solution 1: Checking the Trust Centre Settings<\/span><\/h3>\n\n\n\nWhen the user opens or saves any of their Sage 50 report in Excel 2007 or any higher versions, then, in that case, they need to follow the steps mentioned below.<\/p>\n\n\n\n
\n- The first thing the user needs to do is that they need to open Microsoft Excel on their workstation.<\/li>\n\n\n\n
- The next thing go to the \u2018File<\/strong>\u2019 option that can be found in the menu bar, and in the \u2018File\u2019 menu, they need to click on \u2018Options<\/strong>\u2019.<\/li>\n\n\n\n
- The user will be able to see an option inside the \u2018Options\u2019 menu titled \u2018Trust Centre<\/strong>\u2019.<\/li>\n\n\n\n
- The user must click on the \u2018Trust Centre\u2019 option.<\/li>\n\n\n\n
- Go ahead and click on the option titled \u2018File Block Settings<\/strong>.<\/li>\n\n\n\n
- Now, the user will be able to see different file types with little checkboxes next to them. The user needs to uncheck each file type, then open and save checkboxes to permit Excel to save in the preferred file type. The following are the file types.\n
\n- Excel 2007 and later Add-in Files<\/li>\n\n\n\n
- Excel 2007 and later Macro-Enabled Workbooks and Templates<\/li>\n\n\n\n
- Excel 97-2003 Add-in Files<\/li>\n\n\n\n
- Excel 2007 and later Workbooks and Templates<\/li>\n\n\n\n
- Excel 97-2003 Workbooks and Templates<\/li>\n\n\n\n
- Excel 95 Workbooks<\/li>\n\n\n\n
- Excel 2007 and later Binary Workbooks<\/li>\n\n\n\n
- Excel 95-97 Workbooks and Templates<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Once the user has set all of their preferences, need to save all their changes and click the button that says \u2018OK\u2019 to confirm these changes.<\/li>\n\n\n\n
- After that, the user will be required to re-run their report in Excel, and their issue will have been eliminated.<\/li>\n<\/ul>\n\n\n\n
<\/span>Solution 2: Verifying the Microsoft Excel Default view for the new sheet<\/span><\/h3>\n\n\n\n\n- The first thing the user needs to do is that they need to locate the Microsoft option located at the top left corner of the screen.<\/li>\n\n\n\n
- Once the user has successfully located the Microsoft option in their workstation, they need to choose the option titled \u2018Excel<\/strong>\u2019.<\/li>\n\n\n\n
- After that, the user needs to select the button titled \u2018Popular<\/strong>\u2019.<\/li>\n\n\n\n
- Then needs to navigate to the option titled \u2018When Creating New Workbooks<\/strong>.<\/li>\n\n\n\n
- After the subsequent step, choose the \u2018Normal View<\/strong>\u2019 that can be found in the drop-down that says \u2018Default View<\/strong>\u2019 for the new sheets.<\/li>\n\n\n\n
- Click on the button titled \u2018OK<\/strong>\u2019, and their issue should be eliminated after that.<\/li>\n<\/ul>\n\n\n\n