Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
3
2- +1
9 Comments
Excel thinks your worksheet iss too large. I.E in Excel 2003 the maximum book size was
1-65536 rows, A - ZZ columns
try selecting all the columns that are unneeded, all the way to ZZ and deleting them
then try your insert operation again.
1-65536 rows, A - ZZ columns
try selecting all the columns that are unneeded, all the way to ZZ and deleting them
then try your insert operation again.
first, go select the entire column to the right of your last column of data, hold "shift" + "end" and press the right direction key. This will select all blank rows to the right of your data, right click on one of the columns and hit delete. Do the same for the row after your last peice of data but press the down direction key. This should do it
Active today
I am able to delete the row but cannot “ INSERT” the row again same error . only for one particular file
is the file .xls or .xlsx ?
if it's .xls, try to "save as .xlsx, and eventually reopen the file after that ....
if it's .xls, try to "save as .xlsx, and eventually reopen the file after that ....
Can I just confirm that you deleted all columns after your data until column 'XFD'
and all rows after your data until row number '1048576'?
and all rows after your data until row number '1048576'?
Featured Post
![[eBook] Windows Nano Server](https://filedb.experts-exchange.com/files/public/2017/6/24/1329f749-2f43-4bd1-8413-3b5b5ab33fc6.png)
Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial hows how you can integrate Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease.
The following video show how to bind OSX Mavericks to …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
- Windows 10
- Windows Vista
- Windows 8
- Windows OS
- Windows 7
- Microsoft Legacy OS, Windows XP, *Scripts, *task scheduler
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 5 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.