We help IT Professionals succeed at work.

Could SAP code cause problems in large Excel files?

Sandra Smith
Sandra Smith asked
on
347 Views
Last Modified: 2013-12-08
I have several large Excel worbkoos with code imbedded that creates the SAP menu items.  It runs about 60 pages.  Problem is, my workbooks are crashing now, losing data, not saving or just plain stalling, going nowhere.  I have never had a problem with Excel like this before.  The workbooks are large (40mg) but this should not be an issue.  There were a lot of unused links, which I cleared and that seemed to help somewhat, but I have lost data FOUR times today and have accomplished virtually nothing.  I am campaigning to get the SAP extraction into its own workbook, but need some sort of confirmation that it is contributing to the problems.
ssmith
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2007

Commented:
Large Excel sheets in general can be troublesome, especially if there a constantly major changes beinf made.

I would start from scratch, new Woorkbook, and copy and paste JUST the info you need.

Thi cleans up a lot of leftover junk that can cause crashes.

Also make sure that you get any patches and Service packs for your Excel from the MS site.

I hope this helps !
Sandra SmithRetired

Author

Commented:
Would massive amounts of VLOOKUPs also cause problems?  Both internal and external.  There could easly (and I am not kidding) be about 2500 PER worksheet and there are about 40 worksheets per workbook?
CERTIFIED EXPERT
Top Expert 2007
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Sandra SmithRetired

Author

Commented:
You confirmed something I thought.  I mentioned the paging issue to the IT person and he just dismissed it.  So, I don'tthink he understands and I am stuck, I am a contractor so have no clout.  I will have to devise another solution, thank you.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.