Skip to main content

Referencing a spreadsheet tab title in a cell

By

Problem:

Referencing a spreadsheet tab title in a cell

Solution:

 a) First save the workbook.
b) Then paste the formula given below in a cell to get reference.

 =MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,31)

c) See the magic

Comments

Post a Comment

Please feel free to add your suggestions.

Popular posts from this blog

Office 2013 Error "Microsoft Word has stopped working".

By
Problem: Office 2013 Error "Microsoft Word has stopped working". Cause: This issue could in office 2013. 1.) Abby Fine Reader 2.) Graphic Card Driver. 3) Any Third Party Addin. Solution: Method 1: 1) Look for Abbyy Fine reader in control panel. 2)Remove it from the program list. 3)Restart the computer and check the status. If you are not able to remove it update the latest Update for Abbyy Fine Reader from their website. Method 2: 1) Try to disable Graphic adapter from Device manager Locate Device Manager: Right Click on My computer-->Properties -->Device Manager. 2) Open office application. 3)Check the status. Method 3: 1)Open any office application. 2)Open file-->options--Advance. 3)Disable Hardware Acceleration. Method 4: 1)Open Event Viewer by Run Window(Crtl+R) 2) Type eventvwr.msc and look for the office error. 3) Look for faulting module and rename the file from the file location. 4) Open office application and
1 comment
Read more

Setup cannot find office.en-us\dwtrig20.exe during office installation

By
Problem:  Setup cannot find office.en-us\dwtrig20.exe during office installation Solution: Method 1 : a) Uninstall skype form control panel. b) After installing office, re-install skype. Method 2: a) Browse disk by right clicking on it with mouse. b) Double click on setup.exe file from the same location. Method 3: Note: Take backup of your registry before modifying it.  For registry backup: open "run" >> type "regedit" >> goto "file" >> click on "export" on desktop. a) Edit the registry. HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE Delete the keys (items) you find in the OFFICE folder but not the sub-folders. This removes traces of previous installs to avoid possible conflicts when installing the new version of Office. b)HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE > DELIVERY > SOURCEENGINE > DOWNLOADS Delete the keys (items) you find here.
2 comments
Read more

We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair it now?

By
Issue: We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair it now? This error occur due to some compatibility with the older version office installation. 1.        Go to C:\Program Files (x86)\Microsoft Office\Office15, look for EXCEL.EXE 2.       Right Click on this, Properties, In Compatibility tab, check ""Run this Program as an Administrator" 3.       Start the Excel. You might again get the error. Close Exel and uncheck ""Run this Program as an Administrator"". Start Exel again. You should not get the error anymore. 4.       File > Options > Advanced - In General section (go very much down in Advanced), check ""Ignore Other applications that use Dynamic Data Exchange (DDE)"". Close and re-start the Excel. Uncheck ""Ignore Other applications that use Dynamic Data Exchange (DDE)&q
Post a Comment
Read more