In excel 2007 all service packs.

Create a scatter plot with data greater than 1E13.
Select logarithmic axis with any base (such as 10)
Choose major and minor gridlines.

When the data is large ( 1e13) only major gridlines show up. Minor
gridlines only does work, but not major *and* minor.

Are their any solutions?

It's almost impossible to read a log plot without minor gridlines, and it's
important to highly the major lines as well with a dark line. Log plots are
essential in any engineering or scientific plotting.

Excel is slowly and painfully becoming quite standard for this type of
plotting.