# toad 10.1 EXPORT DATASET has a problem when creating an EXCEL FILE

**URL:** <https://forums.toadworld.com/t/toad-10-1-export-dataset-has-a-problem-when-creating-an-excel-file/9308>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 3, 2010, 2:20pm UTC](https://forums.toadworld.com/t/toad-10-1-export-dataset-has-a-problem-when-creating-an-excel-file/9308 "2010-03-03T14:20:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [March 3, 2010, 2:20pm UTC](https://forums.toadworld.com/t/toad-10-1-export-dataset-has-a-problem-when-creating-an-excel-file/9308/1 "2010-03-03T14:20:23Z")

</div>

We tried creating an EXCEL FILE from a view using Toad 9 SAVE AS facility and  
using Toad 10.1 EXPORT DATASET.

Both create a seemingly similar XLS file EXCEPT that with Toad 9 the headings  
have a grey background. In Toad 10.1 they do not. That seems only a cosmetic  
difference.

BUT there is also some other difference. The Toad 10.1 created file is smaller  
than the Toad 9.1 created file and this Toad 10.1 created file is not usable in  
a Word document as an external source for mail merge. But if you open the Toad  
10.1 created file and just save it becomes bigger and is now usable in Word as  
an external source for mail merge.

So we have a work around but it should be fixed.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 3, 2010, 2:22pm UTC](https://forums.toadworld.com/t/toad-10-1-export-dataset-has-a-problem-when-creating-an-excel-file/9308/2 "2010-03-03T14:22:44Z")

</div>

The grey header has been added back in beta.

I’ll investigate the Word compatibility thing.