Circular Reference Warning/Error message

In Excel when you refer the cell where the formula lies in, it is a circular reference as you get the workbook confused...

For Ex: You are writing a formula in A1 and the formula you enter is =Sum(A1:A5) this is a circular reference as you have the formula in A1 and you want the sum to include A1

Now the frustrating part in the circular reference error message is that it doesn't point you to the location which has the error.

Thankfully there is an easy way to figure out which cells have circular reference:
To locate circular references: Go to Formulas --> Error Checking --> Circular Reference
(Excel 2010)

Once you hover over it, you will see all the cells which have circular references...you can then rectify the errors...

there are resources which explain in good detail:
Video

or in excel help go to "Excel 2010 Home > Excel 2010 Help and How-to > Formulas > Correcting formulas"

Comments

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 quotes wget “<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 way wget --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

Ubuntu: "Unlock login keyring" message "the password you use to log in your computer no longer matches that of your login keyring"

Resetting all the keyring passwords: Navigate to Places > Home . Press ctrl h t o view "hidden files". Navigate to .gnome2 > keyrings and delete login.keyring Using the same keyring (resetting keyring password but keeping old passwords in keyring): 1) Make a backup of the keyring cd ~/.local/share/keyrings/ cp login.keyring login.keyring.backup and after that delete login.keyring file rm ~/.local/share/keyrings/login.keyring 2) Create a new keyring file from Gnome Keyring with the name "login" 3) Replace the new keyring file with the backup of the old keyring file cd ~/.local/share/keyrings/ mv login.keyring.backup login.keyring Note: before Ubuntu 12.10 the path to the keyrings folder was ~/.gnome2/keyrings/ instead of ~/.local/share/keyrings/

Tech Talk

Search This Blog