Microsoft Office Forums Data Processing is taking so slow

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2019, 09:10 PM
Marcia's Avatar
Marcia Marcia is offline Data Processing is taking so slow Windows 7 32bit Data Processing is taking so slow Office 2013
Competent Performer
Data Processing is taking so slow
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default Data Processing is taking so slow

Hi all, I have a table that is only 3,700 kb, 3700 rows and 50 columns. My problem is data entry, editing, inserting rows and inserting columns take more than sixty seconds to be done. There are no conditional formatting and macros, just multiple formulae. I brought my computer to a technician to clean it from unnecessary apps and programs but the problem still persists. Another table of the same formatting and formulae but with more that 7000 rows doesn't have the slow processing problem. Any solution to this problem would be very much appreciated. Thank you.
Reply With Quote
  #2  
Old 05-02-2019, 11:09 PM
xor xor is offline Data Processing is taking so slow Windows 10 Data Processing is taking so slow Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Can you possibly share the file? (Go Advanced)
Reply With Quote
  #3  
Old 05-03-2019, 01:53 AM
Marcia's Avatar
Marcia Marcia is offline Data Processing is taking so slow Windows 7 32bit Data Processing is taking so slow Office 2013
Competent Performer
Data Processing is taking so slow
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default

Here's the file.
Reply With Quote
  #4  
Old 05-03-2019, 02:44 AM
xor xor is offline Data Processing is taking so slow Windows 10 Data Processing is taking so slow Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Where is the file
Reply With Quote
  #5  
Old 05-04-2019, 04:03 AM
Marcia's Avatar
Marcia Marcia is offline Data Processing is taking so slow Windows 7 32bit Data Processing is taking so slow Office 2013
Competent Performer
Data Processing is taking so slow
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default

Oooppps, the file failed to upload, here it is but I had to delete several rows to reduce the file size to less than 500 kb. The sheet is part of a 10 sheet workbook where the data in the nine sheets are all linked and extracts from the tData table.
Attached Files
File Type: xlsx SlowFile.xlsx (425.5 KB, 5 views)
Reply With Quote
  #6  
Old 05-04-2019, 05:49 AM
xor xor is offline Data Processing is taking so slow Windows 10 Data Processing is taking so slow Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Hi

File size 420 kb and I can't recognize any of the problems you mention.

I think the only way I might be able to help is if you can send the full file to me via Personal Message. It is up to you if you will try it that way. Still I don't guarantee anything.
Reply With Quote
  #7  
Old 05-04-2019, 11:12 PM
Marcia's Avatar
Marcia Marcia is offline Data Processing is taking so slow Windows 7 32bit Data Processing is taking so slow Office 2013
Competent Performer
Data Processing is taking so slow
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Hi

I might be able to help is if you can send the full file to me via Personal Message.
Hi Xor, there is no option in the private message for attaching a file.
Marcia
Reply With Quote
  #8  
Old 05-04-2019, 11:18 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Data Processing is taking so slow Windows 7 64bit Data Processing is taking so slow Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,400
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.
That is why there is no way to attach a file to private messages
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #9  
Old 05-05-2019, 12:02 AM
xor xor is offline Data Processing is taking so slow Windows 10 Data Processing is taking so slow Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Quote:
Originally Posted by Pecoflyer View Post
The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.
That is why there is no way to attach a file to private messages
@Pecoflyer

My intention was no way to violate the forums purpose.
If you read the whole thread I guess you will agree to that.

I should have written that she via Personal message could tell me her e-mail address so that afterwards a could give her mine and then she could send the full file to me.

How do you otherwise think that I (or for that matter anyone else in the forum) should be able to possibly help her?
Reply With Quote
  #10  
Old 05-05-2019, 07:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Data Processing is taking so slow Windows 7 64bit Data Processing is taking so slow Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,400
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Just reminding of the obvious. You of all people should understand why, being active on so many forums
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #11  
Old 05-07-2019, 04:20 AM
Marcia's Avatar
Marcia Marcia is offline Data Processing is taking so slow Windows 7 32bit Data Processing is taking so slow Office 2013
Competent Performer
Data Processing is taking so slow
 
Join Date: May 2018
Location: Philippines
Posts: 208
Marcia is on a distinguished road
Default

Thank you Xor for looking into the file. Xor deleted lots of errors stored in the file reducing it to about 2K kb. The workbook is full of formulas, about 80% so in order to fast track data entry, I disabled them for activation later on.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to automate spreadsheet processing Musab Excel Programming 1 05-24-2018 04:56 PM
Data Processing is taking so slow Average Processing Time christian.calimlim22 Excel 3 04-04-2017 11:25 PM
Batch document processing SadielCuentas Word VBA 0 04-19-2016 09:34 AM
Word Processing VERY slowly zswindle Word 4 01-04-2016 04:18 PM
Data Processing is taking so slow Slow internet = Slow Word... User12344321 Word 4 09-21-2015 12:54 PM


All times are GMT -7. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft