• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Disabled Refresh Data Menu Choice

Q1:I receive a message that I must refresh the data of the PivotTable, but the Data, Refresh Data menu choice is disabled.
This problem appears to be the result of a minor bug in Excel's PivotTable code. To enable the Refresh Data menu choice, type a few characters in any empty cell and then delete the characters.

Excel Workbook Won't Embed in an Object Frame

Q1:A message box appears, indicating that the Excel worksheet is corrupted, that Excel is not properly registered, or that not enough available memory exists to open Excel.
Close other open applications and try again. If the procedure continues to display error messages, exit Windows and start over. (An application has failed to release its global memory blocks when closing.) If you continue to receive error messages that refer to the Registry, you need to verify with RegEdit.exe that the Registry entries for Excel are correct.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint