Over 1 million tech questions and answers.

Unlock Password Protection from Excel Workbook

Q: Unlock Password Protection from Excel Workbook

Unlock Password Protection from Excel Workbook with the help of Mask Attack, Dictionary Attack, & Brute Force Attack by eSoftTools Excel Unlocker Tool. You can also, Unlock Word file password and Access file password with supported versions up to 2019 and Windows versions up to 10 (32-bit, & 64-bit). User can try its FREE DEMO VERSION to satisfied with this software working process.

Get More Info:- Search On Google eSoftTools Excel Password Recovery

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Unlock Password Protection from Excel Workbook

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 75.2

I am copying an excel worksheet from an existing workbook to a new workbook using a macro. The sheet contains a Private Sub. I want the new workbook to have the Private Sub password protected. Is there a way of writing this into the macro of the originating workbook?
 

Read other answers
RELEVANCY SCORE 74.4

Hi all.

As I have solved a few of our IT problems at work, I am being held as our expert...thus expected to know how to do everything the managers want done!

About 80% of our computer files are done in excel, but there are a few workbooks which contain sensitve data on our customers, so the manager wants them password protected.
I have looked at the options in excel, and tried the protection option, but that just seems to stop people from making changes...they can still access and read the file.

I don't have excel at home so I can't play around with it to find out the answer myself.

I looked at the sharing/security properties, and that seems to choose which pc the file is available to....we need it available to all 3 pcs, as we just use whichever is free, but that it can only by opened by myself and the 3 managers.

We all use one standard log-in, so I can't make it available just to certain users.

Thanks in advance!
 

A:Solved: Password protecting an Excel workbook

Read other 6 answers
RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 68.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 66.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 66.4

I have a user that is having a similar problem to the one described in this thread: http://forums.techguy.org/business-applications/593620-solved-excel-password-protected-files.html

The difference is that she is having this problem in Excel 2010. I tried navigating to File > Options > General and then removing her name from the 'Username' field, but after saving the workbook, closing Excel and then trying to open the workbook again, she is prompted by Office to enter her name and initials. Even if we delete her information from here and click 'ok' the password prompt comes up (as it should) but still shows '<file name>' is reserved by <user>...

The workbook was originally created as an Excel 97-2003 workbook and apparently has macros; I tried saving it as a .xlsx but had to save it as a macro-enabled .xlsm file. I then tried the same steps to remove her username, but this did not resolve the issue.
 

A:Excel 2010 password protected workbook "reserved by <username>"

Just a bump since there has been no response
 

Read other 3 answers
RELEVANCY SCORE 65.2

I have an Excel workbook titled "Password" in which I keep all the passwords I use (lots) - this workbook is password protected so I really only need to remember one password
This morning when I got to work I opened the workbook
It asked for the initial password which I entered and was accepted
It then opens the dialogue for the Write or Read Only
Under the line
"PASSWORD" IS RESERVED BY
it gives a line of funny characters (blocks etc) which I had never seen before
Whether I enter the password or select ReadOnly I get kicked out of Excel
with a blank dialogue box headed PROGRAM ERROR
I tried several times and even rebooted with the same results
Please help
 

A:Excel - Password protection

Hi meksteen,

is the spreadsheet on a networked drive or are you on a network?

if so ask your administrator to check if the file has a lock against it, if so clear it, then you can try to open it again.

not sure if this helps, otherwise you spreadsheet may be corrupt (gulp).

Hew
 

Read other 2 answers
RELEVANCY SCORE 65.2

Hi Guys

I'm having a problem with a user on Excel, the file is an xlsx (Excel 2007 Format) we are using Excel 2000. The Microsoft compatibility pack converts the file to a readable format, the problem is it asks for a password to open it.

I have tried and I can open it, plus a few others have also tried and have been able to open it. It seems to be this one users profile but not sure what’s causing it any ideas?

Regards

shenmue232
 

A:Excel Password Protection

Might want to ask a moderator to move this to the Business Applications category. You can do so by clicking Report on your first post.
 

Read other 1 answers
RELEVANCY SCORE 64.8

Morning from England,

One of our clients has a problem, when they receive an email with a password protected excel sheet and try to open it, they get a message saying that the password is incorrect and to verify that caps lock isn't on, before they even have a chance to enter the password.

Apparently they could do this last week, but not today.

They can save the excel attachment and open it that way and it allows them to put in the password. (But I don't think she is interested in doing this and I have no idea why it matters, but the customer is always right, apparently)

I know you should never take the story of the client as gospel, because most of the time it is wrong, but I'm just wondering if it is possible to open a password protected excel document from outlook, or does it have to be saved first?

If you can open one from outlook, how can I fix it.

Thank you for any help provided.
 

A:Solved: Excel Password Protection

When an excel file is password protected it will always prompt for a password.
If you open an attachment in Outlook, a copy is placed in the local temp folder but it's still Excel and it will still ask for a password.
I think your client has the following problem:
If you have preview frame on, it could be that since you want to 'preview' the message an maybe the Excel file too, it will prompt for a password to open it in the preview, this would explain the reason the password prompt appears, ask your customer to colse the preview option and try again.
In teh Excel file allows to read without a password but edit with a password then they should get the choice Open as read only besides the password prompt, so.
A client may be king but not everybody has to bow for a king.
 

Read other 2 answers
RELEVANCY SCORE 64

Hi
i have 1 T external Hard that is encrypt by Bitlocker tool .... when in plug in my hard into my computer and enter unlock password it doesn't open it and shows responding error ...i try with the others computers and in shows same error...i have a very very
important files and information in my hard...and i didn't save my recovery password ...please please help me...
Thanks
niusha

Read other answers
RELEVANCY SCORE 64

I am using Excel 2000 and have a spreadsheet that is password protected from a previous employee. I have saved the sheet under another name with no luck and I have used the edit/Move or copy command to move the sheets to another workbook with no luck. Any other suggestions? Thanks
 

A:Excel Password Protection Problem Follow up

http://www.theofficeexperts.com/VBASamples/Excel02.htm
 

Read other 1 answers
RELEVANCY SCORE 64

how can i over write password in an excel file? actually it is my file but someone put password on it how can i get rid of that password?????
 

A:How to remove password protection in excel file

Your best bet is probably googling "Excel password" and seeing what comes up. There are MANY many utilities out there for finding out the passwords in a spreadsheet, and you should be able to find one that works for you.

Do note, tho, most of the good ones are commercial
 

Read other 3 answers
RELEVANCY SCORE 60.8

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 59.6

Some time ago I protected the Excel 2010 file from the path File > Protect workbook > Encrypt with password and gave it a password. Now that I removed that password via below method:

Open the workbook and use Save As
In the lower right of the file window will be "Tools"
Choose "General Options"
Clear the password.
Save over your old file.

the file is openable without wanting a password. But the problem is when I open it and close it immediately, even without moving the active cell, the message "Do you want to save the changes you made to 'test.lsx'?" appears. While there hasn't occurred any changes to that file so why I face this message any time I want to close the file?
Hasn't the file been corrupted?

A:"save the changes” message after removing the protection from workbook

I've seen that happen because there are changes to the properties of the file that can't be seen, example when opening .doc files in Word 2007 or 2010 then closing saving the .doc format.

Read other 1 answers
RELEVANCY SCORE 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 56.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 56.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 56.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 56.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 56.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 56.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 56.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 56.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 56.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 56.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 56.8

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vessel’s name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename – based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

 

Read other answers
RELEVANCY SCORE 56.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 56

I have a non-shared Excel spreadsheet that users have saved multiple copies of.  Some are Excel 2010 and some are Excel 2003.  I need to compare and merge them back into one spreadsheet which I will then share.  What is the best (and easiest!!) way to do this?

A:Merge Non-Shared Workbook in Excel

sounds like a manual job.... you can't automatically select the best data over a range of different spreadsheets.
 
As long as the macros were created with the 2010 version you should be able to view them within the same instance of Excel.

Read other 1 answers
RELEVANCY SCORE 56

I have a audit template that takes two files and compairs them and opens a new workbook to display the differences. This new workbook is then saved to a specific location for audit reasons.

In the new workbook created, I'm wanting to "remove" all the toolbars and menus so a user can't safe the file to another location by mistake.

Is there a way for the creating template to "insert" macros into the newly created workbook to do this? While I could just create new worksheets in the "creating" template workbook and remove the ones I don't need, I'm trying to keep the size of the file down by not having all the macros that created the new template in the final product.
 

A:Have Excel VBA Create A Macro In A New Workbook

Just for some thoughts on this concept, I would suggest you read this:
http://www.vbaexpress.com/forum/showthread.php?t=26263&highlight=hide+toolbars
 

Read other 1 answers
RELEVANCY SCORE 56

I'm having the dreaded "shared workbook" issues.
 
I have many users at different points in the week complain about issues with a shared workbook. May it be slow to open, slow to save, random crashing, loss of data, loss of changes, I get it all!
 
I've found going to each computer to try to diagnose and/or repair excel is futile. Does anyone have any insight as to how I can get around this? I was thinking either find out how to use Microsoft Access with their workbooks or convincing the management to assign one person in their team to do the excel spreadsheet updates.
 
Your help will be GREATLY appreciated.

A:SHARED EXCEL WORKBOOK CORRUPTION

Just got off the phone with Microsoft which was no help. It seems like there are no fixes whatsoever for this issue. I'm leaning more towards using Access with the workbooks to alieviate this issue. However any help will be appreciated.

Read other 1 answers
RELEVANCY SCORE 56

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

Read other answers
RELEVANCY SCORE 56

Good Day Moderator,
just got to the core... I've problem to open an excel workbook which contain macros from visual basic at run-time. Thats it, I don't know what properties or method that I should used.

For your illustration, perhaps I should write some of them in here ( hope you don't getting bored with this )

dim strFile as String
dim objExcel as Excel.Application

strFile = InputBox("Please input your excel file full path :","C:\")

Set objExcel = CreateObject("Excel.Application")

With objExcel
.DisplayAlerts = False
.Workbooks.Open strFile

MsgBox "Your name is : " & .ActiveSheet.Range("D1")

.ActiveWorkbook.Close False
.Quit
End With

While trying to process the Msgbox's function, it said that "Object variable or With block variable not set", just like if the object has not successfully created.

Do you have any idea with this ? I really don't know what to do.
Thanks a lot for your help and have a nice day

Best Regards.
 

A:Open an excel workbook which contain macro from vb

I don't claim to do VBA, but I dabble.

In the first place, if you are creating this code in an Excel file, I don't think you need to declare Excel as the application at all.

I think you should be creating a workbook object and not an application object.

I just tried it out, and I get that darn Error 429, but I think that's better than what you're getting.
 

Read other 1 answers
RELEVANCY SCORE 56

Hi,

I have Excel 2007 and want to use MS Outlook 2007 for emailing. However, I do not want to email the whole workbook but only one sheet,or sometimes just a small selection and this does not seem possible at the moment.

I can copy one sheet over to a new workbook and then email the new workbook but I wondered if there was a quicker way to do it. I have heard that there are Add-Ons that can be downloaded which allow for only one sheet to be emailed. I found one called RDB Mail but as I went through the procedure I got warnings that it may have been an unsafe site so I did not continue with it.

Does anyone know of a safe way to do this? And, has anyone heard of RDB Mail (I found it on a Microsoft site) and, if so, is it safe?

A:Emailing only one sheet from an Excel workbook

Have no idea about RDB Mail. As for emailing one sheet? Does it have to be as an attachment, or can the sheet be embedded in the email?
If it can be embedded try the following for emailing from Excel:

Step One: Next to the save icon there is an icon that looks like a letter and envelope. Click this icon.
Step Two: Excel will prompt, and ask if you want to send just the active page/current sheet, or the entire workbook.
Step Three: Excel should copy the sheet to a new email message in your default email program.

If the spreadsheet needs to be an attachment? I don't know of any other way than creating a new single sheet workbook as you stated.

Maybe someone else has a tip or clue I'm unaware of.

Read other 6 answers
RELEVANCY SCORE 56

It seems to me that I used to be able to set up my own default Excel books and worksheets. I would set formats, toolbars, footers, etc. the way I liked them then save the sheet as “sheet1.xlt” and the workbook as “book1.xlt”, and put these in the XLstart folder. That way, when I opened a new workbook, or inserted a new sheet, the sheets are formatted they way I want them. But that doesn’t seem to work now. I’m using Excel 97 and Win XP. Before I was using Excel 97 and Win98. Did I miss a cog somewhere? It’s been a long time since I did this and perhaps I missed a step.

Don
 

A:Excel 97 Default Workbook/Sheets

Read other 6 answers
RELEVANCY SCORE 56

Got a file that I can make multiple updates to, multiple saves. Then I make one more modification and save and.... it just WILL NOT SAVE any more modifications. Not a HUGE file, under 5,000 kB.

Suggestions?
 

A:Excel 2010 workbook not saving...

Read other 13 answers
RELEVANCY SCORE 56

When I try to delete either in Excel 2016 I get a message that tells me to unhide the sheet. The sheet is there in front of me, the "hide/unhide" says nothing is hidden and I am confused. Can this be resolved?

Also, how do sheets get hidden without my doing anything knowingly?

Thanks
 

Read other answers
RELEVANCY SCORE 56

hi,

i have a Excel workbook that consist of 3 worksheets and there are some formulas in each of those sheets.

the problem is that each time I open the workbook there will be a "update link" message that appear (pls see the attachment). that's strange 'cause I have never inserted any links before.

is there a way to display all the links that are present in the worksheet and prevent this message from re-appearing?

thank you
 

A:Cannot Find the Links in Excel Workbook

Try Bill Manville's add-in -- http://www.oaltd.co.uk/MVP/MVPPage.asp
 

Read other 2 answers
RELEVANCY SCORE 56

Good morning,

My head office has implemented a new way of recording operatives working hours.

It used to be based on a persons name and then the number of hours worked on a job. You could get about 20 men on one sheet.

Now thy want it based on the Job so each job has its own sheet, so we are swimming in paper!

What I need is a page where I can have a drop down box with the following criteria:

Name
Trade
Week Ending

and then

The jobs that that person did, so:

The Job
The day
The Number of hours

I dont want to manually enter all of this in a load of different spreadsheets so i there a way of just using one and when i hit 'Enter Data' or something it populates pre-made spreadsheets that I can print?!

Ive attached what ive got so far.

Regards
James
 

A:Excel - Using one Workbook to populate information in another

Read other 16 answers
RELEVANCY SCORE 56

I have an Excel macro that opens another workbook. If the macro errors out, how can I close the second workbook that was opened?
 

A:Excel Macro -> Close Second Workbook

Read other 12 answers
RELEVANCY SCORE 56

This is a followup to my "Data transfer between 2 different open Apps" thread, which is now functioning...sort of. I have not found a way to access the data from the workbook which is opened in the second application. I can only reopen it from it's last saved location, which is OK, if I know that the workbook has not been changed since it was last saved. Part of what I'm doing uses a IsFileAlreadyOpen function (kernal32) as recomended to me in that thread.

QUESTION: I would like to know if an open workbook has been changed since it was last saved. This workbook is in a different app. Is there a function (perhaps kernal32) that can be called to give me the changed state of a workbook?
Thanks,
Tom
 

A:VBA Excel: Check if a workbook has been changed

Read other 7 answers
RELEVANCY SCORE 56

Hi There

I have recorded a macro that opens up a workbook from my C drive as follows:

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

I also recorded a macro that opens a workbook from windows as follows:

Windows("Salem's Point 1L 40M-2423.xls").Activate

I want to combine these two macros to do the following:

If Salem's Point 1L 40M-2423.xls is aready open then do the code Windows("Salem's Point 1L 40M-2423.xls").Activate

If Salem's Point 1L 40M-2423.xls is not open then do the code Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

Please help

Mario
 

A:Excel Macro to open a workbook

Hi Mario,

When you say you open a workbook from your C-drive.
Are you executing your macro from within an Excel workbook or how?
What do you trigeer it with or where do you trigger it from?
 

Read other 1 answers
RELEVANCY SCORE 56

Microsoft Excel 2003 - I need help creating a macro that will link a workbook file with hundreds of other workbooks to create a customer list. All my workbooks are in C:\Documents 2007\Bids\BID____.xls. All files begin with "BID". All workbooks are identical and I only need information from certain cells. (i.e. G8, A6, G6, etc.). I want all the information from each file to go onto one row of the customer list - a new file's information on each row. Does anyone know how to do this? I have spent all day working on it and am about to go out of my mind. I would really appreciate any help. Thanks.
 

A:Excel - Need Workbook Linked to Many Workbooks

Read other 16 answers