Excel files do not open
The problem is this: the portal has created libraries and folders in them in folders are Excel files. Some users do not open files. And most likely due to the fact that the libraries and all the folders are named in Russian, and the ball converts Russian characters into only clear nonsense and the link to the file becomes 500+ characters in size. This problem only occurs on 2010 Excel. And not at all. For someone and for 2010 files open. It is about opening them in the client application, and not in the Web App. And since someone opens up to 2010m, can there be any kind of patch that solves this problem? Ie, someone from us is worth it, but who does not? Or is there another solution ...? Googling of this miracle has not yielded results yet. For earlier, I thank for the answers!
There are 3 answers
Answered on April 2, 2016 03:29
I provide the following procedure: 1. Create two new files in Excel, and call them, for example, and. 2. Open both the created Excel file. 3. In the file on the sheet, select the range of empty cells A1 ... E18. The selected range must be obviously larger than the size of the lost table.Here it is necessary to strain the memory and recall the approximate dimensions of the sheet that we want to restore. If you select a smaller area than the recoverable information takes, you will have to repeat the entire described procedure, highlighting a large area. 4. Press the button in the main menu and select. The highlighted empty range is copied to the clipboard. 5. Press the main menu button and go to the file by selecting it on the drop-down tab. 6. Select the top left cell A1 on the sheet of the opened file. 7. Click the main menu button again, select it in the drop-down menu. 8. In the window of the same name that opens, press the button. Window "Paste Special" 9. Press the button in the main menu again and select it in the drop-down menu. 10. In the window that appears, press the button. The "Change links" window and the "Change" button 11. To complete the process, in the pop-up window, specify our problem file and close the window. The "Change Source" window Recovering information in the excelIn the file we need to see the data from the corrupted file. The recovered information looks like it is shown in the picture to the left of this text. 12.After the recovery of information, you should disable the link file with the file. To do this, press the button of the main menu and select in the drop-down menu. 13. In the window that appears, press the button and close the window.