Skip to main content

“Document Not Saved” error in Excel

Its so common that we convert an excel to a PDF. It happens almost everyday for me.

It was recently that I got to see the error “Document Not Saved” while converting an excel to a PDF file.

 

Here are the steps which helped me resolve the issue:

  1. Step 1: Check for your permissions – Many of the times, a shared file might restrict saving the file into other forms. In this case, get the proper permissions for yourself
  2. Step 2: You have embedded objects in your excel (MS Support Link)
    1. If you do, then the workaround is to remove the embedded objects and try saving the file again
    2. If you don’t know anything about the existence of embedded objects just like I do, then perform the following steps Smile 
      1. Use the Go To option from the Edit menu or use the keyboard shortcut Ctrl + G to open the Go To dialog box.
      2. Click on Special.
      3. Select Objects in the Special dialog box.
      4. Click Ok.
      5. This will highlight all the embedded objects on the excel file – now you can delete them Smile 

Picked up the above information from this link (Thanks!)

Hope this helps!

Comments

Popular posts from this blog

How to check if my xpath is valid using firebug?

Yes, you can verify if your xpath is pointing to the right source on the web application under test using FireBug. Here is how: 


Go to the Web Application under test We'll take Google for simplicity reasons
Open FireBug - Go to the Console Console can also be seen at the bottom of the page, so don't worry they both are the same. They can be switched as follows: 


Type in $x("Your xpath here") on the command line prompt as shown below:

Hit Enter/RunYou will get to see the element which was filtered out with your XPath expression

wget error–“zsh: parse error near &”

There is no doubt that I prefer wget way over any other type of downloads…Syntax: wget <DOWNLOAD_URL>If you get this error “zsh: parse error near &” then its probably because your download URL has a “&” so you should try giving your DOWNLOAD_URL in double quoteswget “<DOWNLOAD_URL>”If you are trying to download from a site which needs you to give your credentials then you can try giving it this waywget --http-user=<UserName> --http-password=<Password> “<DOWNLOAD_URL>”Hope this helps

How to Unpack a tar file on Windows?

On Windows:
You can download a simple command line tool to do this.
You can download the tool from here Usage can be found on the website but pasting it here too for convenience: C:\>TarTool.exe
Usage :
C:\>TarTool.exe sourceFile destinationDirectory
C:\>TarTool.exe D:\sample.tar.gz ./
C:\>TarTool.exe sample.tgz temp
C:\>TarTool.exe -x sample.tar temp
TarTool 2.0 Beta supports bzip2 decompression for files with extensions like tar.bz2 and .bz2.
TarTool -xj sample.tar.bz2 temp
or
TarTool -j sample.bz2
Download TarTool 2.0 Beta from here
Unpack a .txz file on Windows
Use the 7zip tool to unpack a .txz file on windows

On Linux:
You can use the bzip2 and tar combined to do this…
for ex: bzip2 –cd <tar.bz_fileName> | tar –xvf -
This will unpack the contents of the tar.bz file

Happy Un-Tar-ing