What should I do with the Excel file?

I don't know what you mean.

-!Ask the landlord what the problem ......

Please enter data according to the Excel time format specification to avoid similar problems.

Dates are connected by " " or " , and times are connected by ":".

First of all, your time format must meet the time format requirements of excel: if you change the above time to 2013-9-1 18:30, this is a legal format.

Then it is possible to use (b1-a1)*24 to get the desired result, where b1 and a1 are placed for two times.

To change the time format you entered, change it to 2013-9-1 18:30, the year, month and day are connected with "-" or "", and the parameters of the timevalue function must be in text format, or there is an error value! I hope my answer will help you.

You don't need to program this, just create a sheet in table a, copy the contents of table b into it, and then use the ifcount function.

Your two tables, should each cell be the same, and print them if they are different. If so, it's simple. The data of each corresponding cell is removed from each table for comparison.

If the contents of the two tables are the same, but the positions are different, then it will be troublesome, so you have to do two cycles.

Let's take a look at what is the reason for your **big?,If it's because of references to other**、Formulas、Functions、Objects and versions are incompatible,You can adjust and then process,If your data is so much that there is no way to adjust,Then you can only upgrade the computer configuration,Especially when calculating,If the data is large,Be sure to wait until the calculation is finished and then move the mouse,If the calculation process moves,Basically stuck。

Delete the spaces, save them, and the file will be smaller.

TRY ...

Excel itself has a similar function.

Tools-Options-View: Uncheck the box before "Windows in Taskbar".

Open multiple files.

Select and switch files in the Window menu.

If you can press Ctrl and then click the mouse to select multiple ** at the same time, but in different files, there is no better way, the simpler is to make a macro, set a shortcut key, each file is opened once with a shortcut key to run a macro**.

Select 1000 worksheets at the same time with shift, then copy the C10 cell of any worksheet, and then paste the value selectively, and you're good to go.

t1, and then hold down the shift key and select sheet10, so that sheet1 to sheet10 form a workgroup (shown in the title bar of the window). Then go to the page setup operation, and these worksheets will have the same settings.

excel open prompt file error: data may be missing can be solved like this:

1. Excel pops up an error prompt window.

2. After clicking "Open", there are 5 times in a row "File error: data may be lost" window to take a closer look, it turns out that there are 5 worksheets in this document book, so the window appears 5 times. In addition, the contents of these tables are relatively simple, there are no macros or VBAs, and all the information is still there.

3. Right-click one of the worksheets and select "Move or copy worksheets (m)....”

4. Copy this worksheet completely to a new workbook in a new window, save the new workbook and open it again, it is normal.

This solves the problem.

It is a misoperation of the table to the grid, and there is no guarantee.

Enter the excel tool, go into the options, click Save, find the location of the automatic recovery file, copy the address to open, delete all the files inside, and the problem can be solved.

Cause analysis: The current source situation is generally that the user's BAI file is damaged when copying.

Du is broken, or it is not completely transferred when it is transferred, resulting in the file itself being "damaged:." There is also an individual case that the file format is incorrect, for example, the user is using Office 2010 or above, which is an excel document made by excel software, and the default file format is saved when saving, then the user's file is ".".xlsx", and excel documents in this format can only be opened in versions above 2010, and versions below 2009 and below cannot be opened.

Solution: In the case of the first case, the only solution is to make a new copy of the original document. If it is the second case, you need to open it in Excel version 2010 or above, and then save a copy of the format of 2003-2009 version with the suffix "**".

xlsx"documentation.

This is usually the case when your file is copied or not completely transferred, resulting in the file itself being damaged. There are also individual cases where the file format is incorrect, for example, if you use the office2010 version or above, it is an excel document made by excel software, and it is the default file format when saving, then your file is in the "**xlsx" format, and the excel document in this format can only be opened in the version above 2010, and the version 2009 and below cannot be opened.

In the case of the first case, the only solution would be to make a new copy of the original document. If it is the second case, you need to open it in the Excel software of the 2010 version or above, and then save a copy of the format of the 2003 and 2009 version with the suffix "**xlsx"."documentation.

Because there is no actual ** reference, and I don't know if the character does not meet the above two situations, I can only give you a reference, if it is useful, it is the best.

Reinstall Office, and if it doesn't work, there's no way.

I used the Excel2003 version to make the **,Use WPS,There is a problem with the head.。 Just use the higher version to convert it. Open with excel2007 and save as.

xlsx format, open and save it as xls format, and the format is also intact.

This ** is a hidden line.

You do it like this: formatting, lines, unhide.

I don't know if you can send it to my mailbox? If it's not an important document, send it to my email address.

I'll help you see what's going on.

Click on the "Window" above and unhide it on it.

1. First of all, open the file that needs to remove the words on the first and second pages in the computer.

2. When you open the file, click on the view option on the toolbar.

3. Find the normal view in the options of the view and switch to the normal view mode.

4. You can see that there is a title under the normal view mode, and the title function is canceled, that is, the title is canceled in front of the title, and the words on the first page and the second page can be removed.

1. First open the excel file**, and you can see the words on the first page and the second page of the page displayed in **.

2. Find the view option in the toolbar and click on it.

3. After clicking on the official journey, find the option of normal in the view, and click to switch to the normal view.

4. After entering the normal view, click the browsing mode in the lower right corner, and remove the front of the title in the page settings, so that you can remove the words on the first and second pages.

1.In the background, the words on the first few pages appear (I guess you are more likely to do this), click the "View" selection above.

Normal toggles between Normal and Pagination Preview, which does not affect the printing effect, that is, the number of pages is not displayed when printed.

2.Print it out to show the page number.

In "Page Settings", select Header & Footer - Custom Footer Delete Content Click OK.

This is what it looks like when it is set to "Page Preview", and the "first page" and "second page" displayed represent the layout after printing to the paper.

Just press "View Normal" on the menu above.

It's the first page in the word file, and the second page is in this case! Same as above!

More than 700 ** is not a problem, the problem is that the ** ranks and columns you want to summarize are very regular, or are they unorganized?

If it's very regular, then 5 points can make one for you!

If it's not organized, your bounty is too small!!

It takes a lot of effort to deal with the irregularity!!

You can go to the Internet to find software that summarizes excel sheets in batches. However, software aggregation is generally stupid, and if it is a dirty data structure such as messy, it is estimated that you need to do it yourself.

Is an excel file with more than 700 tables? Or more than 700 separate files?

To do it with VBA.