Hi,
We have a shared network folder and many users have created nesting folders in them as per their requirement. When we try to put a hyperlink in a excel file, it does not work for few deeply nested folders since the total character length in the hyperlink crosses 256.
Is there a way out...
Dear Chandoo-ites,
My Mother-in-law is very creative and loves Designing Rangolis..(floral designs made with different colours and line drawings in rural Indian Households)
She was very pleased when I gave her printed sheets of blank rangoli templates (a matrix of dots evenly spaced and...
Hi,
In one of the load templates we require the user to enter quantity in lbs in one of the column, and the user need to enter the value only upto 3 decimal points.
We could have sent the template with input restrictions through data validations, but apparently we did not. Now how do i check...
Hi,
I am in need of a number format code which will show the vertical axis labels as below
100
80
40
20
0
100 (actually -20)
80 (actually -40)
40 (actually -80)
20 (actually -100)
0 (actually -120)
I hope i made some sense...
Can we show a window in excel where it can reflect that the processor is trying to calculate/ update the sheet with Macros. It does come in bottm right corner, but for ease of use can we show percentage processed in the sheet
Hi, I have an excel template i circulate for users, who enter some data and save filename in a particular format ''their_name+ddmmyyyy.xlsx'' and send me back. Its very difficult to explain everyone to use a same format so that it is easy for me to store, sort the files in a folder. i was...