SBFM2000: Cannot Update Reports After Remapping Data

ID: Q234136


The information in this article applies to:
  • Microsoft Small Business Financial Manager, included with:
    • Microsoft Office 2000 Small Business Tools
  • Microsoft Excel 2000


SYMPTOMS

When you click Recalculate Reports on the Financial Manager menu, the following message appears:

All the reports in this workbook are already up to date. There is no need to update your reports.


CAUSE

This problem occurs when you do the following:

  • You import accounting data into the Small Business Financial Manager.

    -and-


  • You create reports.

    -and-


  • You click Remap Data on the Financial Manager menu.

    -and-


  • You click Recalculate Reports on the Financial Manager menu.



WORKAROUND

Re-create your accounting reports using the Report Wizard. You cannot update existing reports after remapping data to new accounts.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

When you remap accounts to different account categories (for example you move an asset account to an expense account), you cannot use the Recalculate Reports command to update existing reports you have created. You must create new reports based on the new account structure.

Additional query words: off2000 xl2000

Keywords : xlsbfm kbsbt
Version : :; WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: October 27, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.