Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 113
Default Extra 4 columns to left of spreadsheet

We are creating an excel spreadsheet from an Access report using the
"Send..." option.

We are getting an extra 4 (grouping???) columns to the left of the
spreadsheet, looks something like this:

1 2 3 4 Column1 Column2 Column3, etc...
-
|
|
|
-

Any ideas what Excel is doing with the data? We are missing the first three
columns of output from the Access report and assuming it is somehow grouping
the data (?) in those mysterious 4 columns to the left of the spreadsheet.
The vertical bracket encompasses all the rows of data in the report.

Any ideas?

Kind Regards,
Leslie
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Extra 4 columns to left of spreadsheet

You can get those outlining symbols in a couple of ways:

Data|subtotals
or
Data|Group and Outline

You can hide the outlining symbols by:
tools|Options|View Tab|Uncheck Outline Symbols

Or you can remove the subtotals or the grouping.

Leslie wrote:

We are creating an excel spreadsheet from an Access report using the
"Send..." option.

We are getting an extra 4 (grouping???) columns to the left of the
spreadsheet, looks something like this:

1 2 3 4 Column1 Column2 Column3, etc...
-
|
|
|
-

Any ideas what Excel is doing with the data? We are missing the first three
columns of output from the Access report and assuming it is somehow grouping
the data (?) in those mysterious 4 columns to the left of the spreadsheet.
The vertical bracket encompasses all the rows of data in the report.

Any ideas?

Kind Regards,
Leslie


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what are the 1-8 grey columns left of the spreadsheet? greg november Excel Discussion (Misc queries) 2 October 4th 06 02:15 PM
looking for an one invoice on an extra large spreadsheet Teresa Excel Discussion (Misc queries) 1 March 17th 06 03:12 AM
extra rows and columns Wooster New Users to Excel 3 December 4th 05 12:45 AM
eliminating extra rows in spreadsheet roger-e Excel Discussion (Misc queries) 2 August 19th 05 07:33 PM
Extra Columns Peco Worker Excel Discussion (Misc queries) 3 May 23rd 05 01:17 PM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"