Title: Strange memory issue
Last modified: January 6, 2017

---

# Strange memory issue

 *  Resolved [rsteinhoff](https://wordpress.org/support/users/rsteinhoff/)
 * (@rsteinhoff)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/strange-memory-issue/)
 * Hi Tobias!
 * I’m encountering a strange memory issue with Tablepress. I have two tables, ID-
   5 and ID-13. I periodically replace these tables using the Excel import function.
   These Excel files are quite big, approx 250 rows with 1 column but lots of data
   in each cell. The two Excel files used to update ID-5 and ID-13 are exactly the
   same size with the same number of rows/content.
 * When I import & replace ID-13 everything goes smoothly. When I import & replace
   ID-5 I get this message:
 * Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate
   7403573 bytes) in /XXXXX/formatting.php on line 4623.
 * I know these memory issues can be tricky to figure out but was wondering if you
   have any insight into this issue. By the way, sometimes the import works despite
   the memory error message–sometimes it doesn’t.
 * Thanks,
 * Ronald
    -  This topic was modified 9 years, 5 months ago by [rsteinhoff](https://wordpress.org/support/users/rsteinhoff/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [rsteinhoff](https://wordpress.org/support/users/rsteinhoff/)
 * (@rsteinhoff)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/strange-memory-issue/#post-8627803)
 * Hi Tobias,
 * I think I figured it out. I have a master table with 500 rows that I split into
   two tables with 250 rows each. ID-5 is one 250-row table and ID-13 is the other.
   I had to split the 500 row table into two tables since I was getting the memory
   error. All was good until I recently got a memory error for ID-5, even though
   it’s 250 rows. However, even though I deleted 250 rows from ID-5, Excel was still
   thinking it was a 500 row table, triggering the memory error upon importing. 
   Rather than deleting the rows I copied the 250 rows to a new excel files to make
   sure it would be seen as a 250 row table, not a 500 row table with 250 rows missing.
   Anyways, it’s working now.
 * Hope this makes sense 😛 Thanks again for best WordPress plugin!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/strange-memory-issue/#post-8629869)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Yeah, the Excel format can be tricky with memory, as it sometimes “hides” data
   internally.
 * The best workaround that I know is to simply save the table to a CSV file in 
   Excel and then import that .csv file into TablePress. That should require much
   less memory.
 * Regards,
    Tobias

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Strange memory issue’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/strange-memory-issue/#post-8629869)
 * Status: resolved