ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extra 4 columns to left of spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/138351-extra-4-columns-left-spreadsheet.html)

LESLIE

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

Dave Peterson

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


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com