+ Reply to Thread
Results 1 to 3 of 3

Not responding - too much text in text box

  1. #1
    Registered User
    Join Date
    02-11-2025
    Location
    Singapore
    MS-Off Ver
    2024
    Posts
    2

    Unhappy Not responding - too much text in text box

    I copied and pasted approx. 300,000 cells of data into a spreadsheet, no issues. I then went to edit a textbox within the same file and accidently posted the 300,000 cells of data into the textbox. This volume of text into the textbox has caused the file to go into a 'Not Responding' spiral. I can wait about half an hour for the file to start responding again, but then I'll try to select the textbox to delete it and end up with a 'Not Responding' greyed out file again.

    I have tried force closing the file through task manager and opening it up again a few times but no luck.

    Any tips on how I can remove the large amount of erroneous text in the textbox and get my file to work again?

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,289

    Re: Not responding - too much text in text box

    Refer yellow banner on top of page. Kindly attach sample file to clear idea.
    Limit of 32,767 characters in each cell


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    02-11-2025
    Location
    Singapore
    MS-Off Ver
    2024
    Posts
    2

    Re: Not responding - too much text in text box

    Hi, this unfortunately is not possible and would not help anyone answer. The file is as mentioned, not responding. There is too much text in a textbox, not a cell, which is causing the issue. Even if I did manage to attach it, I assume someone else would then experience the same issue.
    Furthermore, my query is not related to any formula errors, so sharing the file will not help anyone be able to answer anymore than reading my description of the issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find specific text within text and result dependent text in specified column
    By Eftychia in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2019, 08:39 AM
  2. [SOLVED] Need to show text value of highest recurring text based on another text value
    By retroisbest in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-23-2017, 10:23 AM
  3. Replies: 1
    Last Post: 12-17-2015, 03:35 AM
  4. [SOLVED] Need to Mod Code on red text, I have VBA to distinguish Paid(Black Text) Unpaid(Red Text)
    By Garbology in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2014, 07:55 PM
  5. Replies: 0
    Last Post: 04-22-2013, 12:13 PM
  6. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  7. [SOLVED] Use .text from previous text box in form to prefill text in second text box
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2012, 10:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1