Check your formulas. Make sure the list separator matches the regional settings on your machine.

In F9 when attempting to use the Report Wizard to generate account ending balances the following message appears in cells:  Check your formulas.  Make sure the list separator matches the regional settings on your machine.
1. Verify the registry setting for list separator on the effected workstation matches the regional setting on the workstation:
  • Start > Run > at the open dialog type regedt 32 > OK
  • Browse to hkey_current_user\software\synex systems corporation\F9\5.0\F9 Excel
  • In the name list to the right look for the name listseperator and the data column to see if "," (comma) is set here
  • Change this to "," comma if needed, then save and close the registry
  • Start > Control Panel > Region and Language
  • On the Format tab select Additional Settings > the verify the list separator is "," (comma)
2. On the effected workstation select F9 from the Tool bar > Company Setup.
3. Browse back out to the location of the SQL instance running the database.
4. Toggle the Database setting > select to Apply the changes.
5. Select F9 from the Tool bar > Reset F9 Task Panes.
6. Recalculate the worksheet.

Environment

 F9 Version .exe 5.0.15.0, F9.Dll 5.1.11.0, Version 5.0.0.8 Excel

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.