microsoft excel

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Microsoft Excel

Microsoft Excel

resolvedResolved · Low Priority · Version 2016

Microsoft Excel

I run reports on our Oracle Transaction System and sometimes it contains more than 65k rows. When I export the document to excel, it then splits into two different sheet as it can't save more than 65k rows in one sheet. Is there anyway to increase the number of rows in Excel.

RE: Microsoft Excel

I don't think this will be a straightforward answer...

There is an old version of Excel which had a maximum of 65000 rows. That was a while ago. The current version has over 1 million rows.

By best guess on what is happening is:

the export from Oracle refers to an older version of excel, hence the reduced number of rows.

So i think you have two options:

First but more manual: copy the second sheet data and add that to your first sheet so everything is in one worksheet

Second: speak to your Oracle administrators to see if they can see what is happening on their end. As the data is coming out of Oracle then the settings within Oracle will be controlling what happens to the format of the data.
It's a long time since I've worked with exports from data bases but it could be - I do not know this for sure - that Oracle just needs a newer link to excel. I would ask you Oracle people about this.

Please let us know how you get on.

thanks
Claire

RE: Microsoft Excel

That's great.. You have solved the problem.
I ran a report this morning and as usual it splits the data in two different sheets because of the number of the rows.
I then opened a new blank Excel document and copy/pasted the data from the two sheets into this new document and they are all in the single sheet.

Thank you for your help. Really appreciate it.

Kind regards
Tahir



Customer Service Manager
National Physical Laboratory
Hampton Road, Teddington, Middlesex
United Kingdom, TW11 0LW
Tel: +44 20 8943 6796
Fax: +44 20 8614 0482
Email: tahir.maqba@npl.co.uk
Web: www.npl.co.uk

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

PowerPoint tip:

Saving a Drawn Object as a picture

If you want to reuse an object that you have drawn, you can save it so that it is added to the Clip Organiser.
Right click the object, choose Save as Picture, give it a file name and place it in the relevant location.

View all PowerPoint hints and tips


Server loaded in 0.11 secs.