Question description:
This user has given permission to use the problem statement for this
blog.
Cannot enter new column. Must delete some data?
Solved by T. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/10/2018 - 08:07
Welcome to ExcelChat!
Excelchat Expert
09/10/2018 - 08:07
I see that your question is about adding the new column. I will help you with the problem and explain the solution afterwards.
Excelchat Expert
09/10/2018 - 08:07
Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
09/10/2018 - 08:07
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert
09/10/2018 - 08:08
Do you want to share a file where you have the problem?
Excelchat Expert
09/10/2018 - 08:16
Sorry, I can't help without additional information from your side.. In general it might be connected with the maximum number of columns.. in this case you would really need to delete some of them
Excelchat Expert
09/10/2018 - 08:17
Please let me know if you have any additional information
User
09/10/2018 - 08:41
Please respond.
[Uploaded an Excel file]
User
09/10/2018 - 08:41
Please respond.
Excelchat Expert
09/10/2018 - 08:42
Yes, this is the first message which I got from you
User
09/10/2018 - 08:42
I guess I've been entering them wrong.
Excelchat Expert
09/10/2018 - 08:43
Maybe there was some technical trouble.. I am opening the file
Excelchat Expert
09/10/2018 - 08:43
In which tab of your document do you have the problem?
User
09/10/2018 - 08:43
My data, as best iCan tell only extends to column P.
User
09/10/2018 - 08:43
Not sure what you mean by tab.
Excelchat Expert
09/10/2018 - 08:44
Excel Sheet
Excelchat Expert
09/10/2018 - 08:44
You have many of them in your document, could you specify the one where you have the problem?
User
09/10/2018 - 08:47
I thot i sent that . It would be taxes 2010.
[Uploaded an Excel file]
User
09/10/2018 - 08:48
Have you received my excel spreadsheets?
Excelchat Expert
09/10/2018 - 08:48
Which one should I check? The first or the second file?
User
09/10/2018 - 08:48
the one for 2010 taxes.
Excelchat Expert
09/10/2018 - 08:49
Okay, I opened the file 2010 Tax Breakdown
Excelchat Expert
09/10/2018 - 08:49
On which sheet of this document do you have the problem?
Excelchat Expert
09/10/2018 - 08:49
You have Worksheet 2010
Excelchat Expert
09/10/2018 - 08:49
Rentals 2010
Excelchat Expert
09/10/2018 - 08:49
Worksheet 2011
Excelchat Expert
09/10/2018 - 08:49
And so on
Excelchat Expert
09/10/2018 - 08:49
On which of these sheets do you have the problem?
User
09/10/2018 - 08:50
OK, i'm catching on, sorry. Let me give you the worksheet. Just a minute
User
09/10/2018 - 08:51
that would be "Newer OPS Report"
[Uploaded an Excel file]
Excelchat Expert
09/10/2018 - 08:52
Okay, I am on it
Excelchat Expert
09/10/2018 - 08:52
Could you describe what is the problem here?
Excelchat Expert
09/10/2018 - 08:52
As I can see, it has columns after column P
Excelchat Expert
09/10/2018 - 08:52
Like there is data in column Q and T
User
09/10/2018 - 08:53
Can you erase those columns. I can't find anything there
User
09/10/2018 - 08:54
columns after Q
Excelchat Expert
09/10/2018 - 08:55
Could you share a screenshot of what you see in your file? I don't have any troubles in the file.. It looks like a technical trouble on your side. In general we don't support it, but I can have a look at it, maybe I will able to suggest anything
Excelchat Expert
09/10/2018 - 08:55
I erased the data in columns after Q
Excelchat Expert
09/10/2018 - 08:56
But I don't think that it was the issue
User
09/10/2018 - 08:56
I hope this helps. i don't know how to give you screen shot.
Excelchat Expert
09/10/2018 - 08:56
Here it is
[Uploaded an Excel file]
Excelchat Expert
09/10/2018 - 08:57
I also saved it in the modern format of Excel, maybe it will help
Excelchat Expert
09/10/2018 - 08:57
[Uploaded an Excel file]
Excelchat Expert
09/10/2018 - 08:59
Please let me know if any of these two files had another result for you
User
09/10/2018 - 08:59
OK, give me a minute
Excelchat Expert
09/10/2018 - 09:00
Sure.. but we need to hurry, we have only 8 minutes left
Excelchat Expert
09/10/2018 - 09:00
Could you please also share which version of Excel do you use?
User
09/10/2018 - 09:06
It's older, maybe 2013. I went back to older sheets and I could insert a column. Maybe some thing infected the sheet I was working on. Don't know. Thank you so much for the time you spent. Wish I could be of more help.
Excelchat Expert
09/10/2018 - 09:07
Sorry, but we are out of time. I am sorry about the technical troubles which you had to reach the chat. But in general, the problem which you described is connected with your PC or Excel settings, and it can't be solved by our side, you should reach to your company admin to resolve it for you. Hope for your understanding. If it happens that you have any Excel or Google Sheets related questions in future, please don't hesitate to reach us, we will help you with advanced Excel automation. Wish you a nice day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.