Solved

specific excel file - slow on load

Posted on 2011-09-21
2
312 Views
Last Modified: 2012-05-12
specific excel file - slow on load
format:xslx
size: 368kb  - is that normal for file 130 lines plus colors

i can paste the contents to another file and that would be ok, but i lose all the colors/formatting that are important,

next copy paste operations to file take 3-4 seconds+
file is not hosted on a network

there are no macros to look for

what would i look for in such a file.

is there a way to view source code of an excel file?

some column take more time then others to load.  like price columns that have numeric values vs alphabetic
0
Comment
Question by:Anti-Mhz
2 Comments
 
LVL 1

Accepted Solution

by:
cyberion1985 earned 250 total points
ID: 36575403
Hello Anti-Mhz,

I would advise you to open a new excel sheet. Choose from the menu and click on "Save As". Under the save as you choose the filetype to be XLS and not XLSX. Safe the filename as NEW_ORIGINAL.XLS for example. Now open your real original. While in your original sheet on the original document, press Ctrl&A (to select everything), then Ctrl&C (to copy). Then open navigate into your other sheet on "NEW_ORIGINAL.XLS" and press Ctrl&A (to select everything) and then right click anywhere in the highlighted area and choose "Paste Special". In the paste-special window, make "All" is checked at the top right.

Alternatively, you can open your original document, then save it immediatley as .XLS instead of xlsx.

136KB file should not take long to open. I'm using a 7000KB file, yet it takes only 7 seconds to open and it's from a network. However, I am using Office 2007.
0
 
LVL 1

Author Closing Comment

by:Anti-Mhz
ID: 36579692
paste special worked. thank you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now