ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repeat Rows 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/178676-repeat-rows-2007-a.html)

JudithJubilee

Repeat Rows 2007
 
Hi there,

I've upgraded very recently to 2007 and in a few of my Excel documents is
seems to be stripping the Repeat Rows setting and I'm having to reset them.
Now I know I can create a macro to reset them back and I have done this but
is this a known problem in 2007 or am I missing something. The same files
open up fine in Office 2000 with the Repeat Rows still set.

Cheers

Judith


Tyro[_2_]

Repeat Rows 2007
 
I'm unfamiliar with the "Repeat Rows setting". What is that?

Tyro

"JudithJubilee" wrote in message
...
Hi there,

I've upgraded very recently to 2007 and in a few of my Excel documents is
seems to be stripping the Repeat Rows setting and I'm having to reset
them.
Now I know I can create a macro to reset them back and I have done this
but
is this a known problem in 2007 or am I missing something. The same files
open up fine in Office 2000 with the Repeat Rows still set.

Cheers

Judith




Roger Govier[_3_]

Repeat Rows 2007
 
Hi Judith

I assume you mean Page LayoutPage SetupPrint TitlesRows to repeat at top
of Page
I have not had any problems with that in any of my files (so far) either
xlsx files or older xls files.

Perhaps you just have a glitch in certain files.
Perhaps with the problem files, if you right click the sheet tab(s))Move or
CopyCopyNew Workbook make you settings and save the workbook you will be
able to get rid of the problem.

--
Regards
Roger Govier

"JudithJubilee" wrote in message
...
Hi there,

I've upgraded very recently to 2007 and in a few of my Excel documents is
seems to be stripping the Repeat Rows setting and I'm having to reset
them.
Now I know I can create a macro to reset them back and I have done this
but
is this a known problem in 2007 or am I missing something. The same files
open up fine in Office 2000 with the Repeat Rows still set.

Cheers

Judith


JudithJubilee

Repeat Rows 2007
 
That's exactly what I meant. Just did a quick q without checking what I
wrote! Cheers for translating. I thought it must just be a glitch. Love
asking here so I'm not tearing my hair out trying to find an answer when it's
just the way it is.

Cheers again

"Roger Govier" wrote:

Hi Judith

I assume you mean Page LayoutPage SetupPrint TitlesRows to repeat at top
of Page
I have not had any problems with that in any of my files (so far) either
xlsx files or older xls files.

Perhaps you just have a glitch in certain files.
Perhaps with the problem files, if you right click the sheet tab(s))Move or
CopyCopyNew Workbook make you settings and save the workbook you will be
able to get rid of the problem.

--
Regards
Roger Govier

"JudithJubilee" wrote in message
...
Hi there,

I've upgraded very recently to 2007 and in a few of my Excel documents is
seems to be stripping the Repeat Rows setting and I'm having to reset
them.
Now I know I can create a macro to reset them back and I have done this
but
is this a known problem in 2007 or am I missing something. The same files
open up fine in Office 2000 with the Repeat Rows still set.

Cheers

Judith



All times are GMT +1. The time now is 04:14 PM.

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