Quirk in 8 advanced?

[jeh910]

I had an odd adventure today and thought someone at Filemaker might need to check it out but I don't know how to attract their attention.

I was pleased that you could save to excel spreadsheets since I use the subtotal feature there. I did my work in 8 Advanced then saved directly to an excel file. That was okay and I liked being able to do that but then when I went to the subtotal feature, excel would not sum. It would count but not sum. I tried all sorts of fixes but nothing (or I should say zero) worked. The formulas were stated correctly and the cells that were to be added were the right ones but the answers was incorrectly Zero.

I finally exported the file in the tab-separated format then imported that into excel and when I went to subtotal feature, it summed up perfectly using the same formulas. That is when I thought it might be related to the FM 8 save function. But what would I know?