Controlling Excel cell format at export

[Jonathan Scott via AccessMonster.com]

In Acces97 and Excel97, I have a button which exports a table with the
following command:

DoCmd.OutputTo acOutputTable, "work", acFormatXLS, , True

In the resulting file, I try to add a Sum() function for a column, and
specify the cells to include. When I hit enter, the sum comes to zero when it
should have been some other number.

I then noticed that if I double-click on any of the cells, the Sum() starts
to reflect the actual result. If I double-click on all of the cells specified
in the Sum(), the result is the sum I expected.

So, my question is, how can I make Excel not force the user to do such a
cumbersome and unintuitive action to get the results they need?

Jonathan Scott

 

[Arvin Meyer [MVP]]

Try pressing the F9 key or Ctrl+Alt+F9 to make the worksheet recalculate.
You may get a better answer in an Excel newsgroup.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access