Excel 2007

[tom180]

Problem when using "save as" feature and trying to save spreadsheet as a "95 Workbook" which is required for links to a pagemaker document. Excel shuts down when I try it.
Any suggestions?

 

[AnotherHiggins]

95? Wow.

I just tried it and it worked fine for me.

Have you applied any formatting in 2007?

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[tom180]

I have been doing this for some time...and it has worked fine..if a create a new spreadsheet..it works...it seems I have a corrupt file....I opened a backup file with the same data....added the additional data since the backup and it shut down and wouldn't allow me to "save as" the format I need...I'm wondering if there are size limits I'm exceeding for that format

 

[AnotherHiggins]

How many rows do you have?

I think the maximum number of rows is16,384. Maybe it was less in 95 - I'd have to look it up.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[AnotherHiggins]

All hail wikipedia!

The limit was, indeed, 16,384 (2^14).

link

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[tom180]

Well...I found I had a corrupt file in one of the 8 tabs in the file....after removing it..I was able to save the file in the required format....thanks for the help and suggestions..

 

[AnotherHiggins]

I'm glad you got it sorted out.



[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

John, looks like a DELETE to me, rather than a SORT.

Of course, I'm not privy to the sorted details. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}