Over 1 million tech questions and answers.

automatically populate saved excel document as a hyper link in another workbook?

Q: automatically populate saved excel document as a hyper link in another workbook?


I was wondering if the above can be achieved?
My scenario is I have an issues log and the file name is saved as the issue title is there a way to get the saved file name into another workbook appearing as a hyper link back to the original?

I am assuming VBA will be needed and added on to the code below which i already have, the code takes the value of C9 (the issue title) and saves it in the right folder.

If Range("C9") = "" Then
Msgbox "Please ensure you fill out the Issue Title. Thanks"
Saveactiveworkbook.saveas "C:\filename\filename\ & Range("C9")"
Msgbox " Thank you, your issue has now been saved."

Preferred Solution: automatically populate saved excel document as a hyper link in another 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.)

A: automatically populate saved excel document as a hyper link in another workbook?

Read other 10 answers

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:

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.


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

Read other 16 answers

I have an employee who says that when he has macro errors in his excel 2000 workbook and it debugs the file it crashes and does not save the workbook changes. Any idea why?

Just wondering,

A:excel 2000 - Workbook not saved

Moved this to Buisness, where you may get more responses

Read other 2 answers


I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.

A:Solved: Populate Word Document from Excel

Read other 16 answers

I have an excel spreadsheet I have to work with a lot. I also have to turn around and type it all in again on a word document. I just need to make sure I get two different papers complete. Anyway, how do I automatically populate in word when I put the info on my excel sheet. If anyone could help me with this you would save me tons of work. I would really appreciate it. Thanks

A:How do I atutomatically populate a word document from an excel spreadsheet?

Read other 6 answers

I have the follow code behind the ThisWorkbook_Open Event:

If Weekday(Date, 1) = 6 Then
'Do nothing
End If

Is this the best way to perform this operation?

Also, if the day was not yet Friday, how would I keep the workbook from closing if I needed to open it for modifications?

A:Solved: Excel VBA Automatically Close Workbook

Read other 8 answers

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can

Read other answers

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Sheet... Read more

Read other 3 answers

When I open a workbook, I get a message "this workbook contains links to one or more external sources............."

Is there a way to find the actual cell or cells in my workbook that has the external link?

I tried the "Find" trick, but that does not specify the actual cell(s) with the link.


Read other answers

I get this message when trying to save ONE particular docment that I have named 2005C4LEAVERECORDS
It is on a network drive but I do not have the same problem with the other files on that drive
I have tried "save as " another name on the same drive as well as my C drive but the problem persists
I do not have any imbedded images, macros etc that I am aware of - the file is only 394kb

A:Excel - Document Not Saved


It's possible the file could have become corrupt. Perhaps copy and paste your data to a new workbook and try saving again.


Read other 1 answers

I have a user that about two weeks ago just out of the blue had an Excel document give the error "Document not saved" when she pushed the save button. I tried everything under the sun I could think of but nothing fixed it. The next morning it just worked and we didn't worry much more about it. Jump forward to today. It is happening again to a different file. All other Excel files are opened and saved fine except for this one. We can open it up, make changes but it won't save. We can open it up and save it on other computers just not this one.

Background: She is on a Windows 7 computer with Office 2007. It is an Office 97-03 document. It has always worked before and all other documents work fine.


A:Document Not Saved in Excel

Out of curosity, are all the documents the user is having problems with, 97-03 Office documents, and the ones the user is having no issues with, Office 2007 documents?

Read other 2 answers

Hi I have just saved over a very important excel document then clicked of it. I need to restore the previously saved version but cannot find a way to do it. I have right clicked on the document and clicked "restore previous versions" but there aren't any.

Please could someone help me!

Read other answers

Received and excel file thru email. I saved it to my documents, but when trying to make changes and save get 'Document Not Saved' error. The file is not read only or right protected. I'm running out of ideas, hoping somebody here can help.

A:Excel 2003 'Document Not Saved'

Open a new Excel workbook, copy and paste the data and then save the new workbook?

Read other 1 answers

I have seen this question posted but no good answer.  I have a Excel 2016 generated web page (.mht) and an Excel workbook all stored on a SharePoint 2016 site.  I have generated .png's on one of the Excel worksheets in the workbook and published
that page only as an .mht file.
I need to be able to insert a hyperlink on the .mht page that corresponds to a specific tab (worksheet) in the workbook.  When I create a hyperlink in Excel it will only open to the last page viewed and ignores the syntax to open to the specified sheet.  
Does opening a link to a specified Excel tab work from the browser to an Office application such as Excel.

Read other answers

If I save an Excel file to my server, I frequently get a 'Document not saved' error. The file does not save and a TMP file appears in the save location instead. Similarly, if I open an Excel file on the server and then save it, I get the same error, the original file vanishes and a TMP file appears. This problem occurs about 75% of the time.

I can save Excel files to my c-drive without problems. I can also copy files from my c-drive to the server, so this is the workaround. I can reproduce this problem using two different desktop PCs that are connected to my network.

Details of my setup:
Desktop PCs: MS Vista Home Premium SP1, running Microsoft Office 2007, fully patched
Server: HP MediaSmart EX470, running Windows Home Server, fully patched and up-to-date

Sound familiar anyone? Any ideas gratefully received. Thanks!

A:Excel 'Document not saved' error when saving to server

Eureka! After 30+ hours of wrestling with this, and with the help of users in other forums, I have fixed it. For the record, here&#8217;s what I did:

This was not a server issue. Although I had the problem on two client PCs, the problem was on both of these machines. Having downloaded and run Process Monitor, I discovered that at the time of error, there were other processes going wrong (NAME NOT FOUND errors in ProcMon). One PC had one faulty process &#8211; MSI webcam software by Sonix. The other PC had two faulty processes &#8211; Sonix webcam again and Groove (part of MS Office). By uninstalling those bits of software, the problem is fixed. As we are not big webcam / Groove users, we are happy with the solution here.

Read other 1 answers

Hi all,

I have a (I think) simple question.
I have an Excel sheet with links to another Excel sheet.
Now I want to let users download the first sheet (with links), save them on their computer and let them send the document back.

When I get the document back, the links to the other excel sheet changed.
Is there a way to let the document just stay the original link to the sheet instead of automatic 'update' it when it's saved on another pc and the link can't be found.

So I want to have a cell with the code =if(A1=F6='[sheet 2.xls]Sheet1'!$F6.... stayed this way instead of putting \LOCALS~1\Temp\ etc in front of it.

I've tested this document for myself and I didn't update the links or whatever, so maybe there's some way to prevent this from happening?

A:Excel link not change if saved other computer

Read other 12 answers

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

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

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


Issue is with an Excel document that runs a macro to report information from another data sheet:
Raw data - 3MB
Macro - 8MB
Result file - 120MB
When the macro is complete;
1. The document shows an error when trying to save (see screenshot with error) -- Black icons show within the save window (see screenshot).
2. Copying small amounts of information takes around a minute or longer.
3. Switching tabs sometimes does not change the information on the screen (current tab stays the same but the bottom button doesn't).

Tried the following:
Office 2013 St - downgraded to 2010 to test. No change.
Tested Excel doc on another laptop (identical spec) and saw no issues.

Any ideas?

Thanks in advance.


- System
- Provider
[ Name] Microsoft Office 15 Alerts
- EventID 300
[ Qualifiers] 0
Level 4
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2016-03-08T09:54:44.000000000Z
EventRecordID 3858
Channel OAlerts
Computer BM-LAP-12174.lawlabs.local

- EventData
Microsoft Excel
Document not saved.

A:Excel ('13) - "Document not saved" error + performance issues

My first wild guess -- are you running any combination of privacy and/or anti-ransom utilities? If not, disregard my post.

Read other 1 answers

We have an issue that just developed. I have several Windows XP computers and two Windows 7 Professional laptops. All were working fine editing and saving files to our Window NT server. Now we get a "Document not saved" message. There is a file created, but it has "0" bytes and cannot be opened. The message states that MS Excel cannot open that file becuase it is not a valid "xlsx file. I have run virus scans on all of the coputer using Kaspersky Internet Security 2010. Found some minor bugs that were removed. Files can be saved to individual hard drives and then they can be cut and pasted to the server. I thought the permissions may have gotten changed on th eserver, but I reset those.

A:"Document not saved" to server from Word 07 and Excel 07

Read other 11 answers

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

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers

I have a question userform and a code template - want to use the template and substitute the red text for the QAform textBox info after the button is clicked.

A:QA userform to populate document

Read other 10 answers

i created a document in Excel and when i want to save it there is a warning pop up: "document not saved"
wherever i put it, it's the same.
all other files work perfectly.
strange thing though, the name i wanted to give to the file appears in the menubar of excel and in the taskbar (even though it's not saved).
the file is not in the temporary internet files (OLK... folder)
the document has to many functions and references to just copy it to a new excel file.
it is in excel 2000

could someone help me?

thanks a lot.

A:excel: "document not saved"

Have you been trying "Save as" or just "save"?

Can you post the exact text of the message. Was this originally an attachment in an e-mail? Where have you tried to save it (directory) and what is the name you have given it?

Read other 3 answers


Recieving "document not saved" in Excell 2000

These are docs that are stored on a network drive

only two people access these files and make changes

Both using Excell 2000

I say Docs as this happened earlier in the week on another file

There is plenty of room on the Shared location

Can anyone help ? thanks

A:"document not saved" - Excel 2k

Read other 12 answers

Whenever I click on a hyper link in an email (to unsubscribe from an email) I get the following message: "Your organization's policies are preventing us from completing this action. For more information please contact your help desk." What
do I need to do in order to open links? I am also getting a message from SILVER LIGHT. Any suggestions would be appreciated.

Read other answers

Does anyone know if in Excel 2010 can it automatically populate specific information into different sheets? ie. every time that Monday is selected from a drop down box apply it to the sheet named Monday, if Tuesday apply it to sheet named Tuesday, etc. Any and all help is appreciated. Thank you!!

A:Automatically populate into different sheets


Welcome to the forum.
You can use a worksheet change event for what you want.
Attach a copy of the workbook and we'll do what we can to help you.
Be sure you supply the info as to what want copied the the respective worksheets.

Read other 1 answers


Basically at work we have these documents we need to fill out for each project which could contain up to 25 standard tasks. Each task is shown on a list and also has a table dedicated to it later in the document. The master document contains all 25 tasks and tables but not all are relevant to every job, so we have to go through and delete the ones we don't need. It'd be much more efficient if we could have a way of selecting the necessary tasks (e.g. from an index table on the front page) and having the document populated with only these tasks. I could easily do something similar in Excel using the VLOOKUP command, and if I can't find a better way then that's what I'll have to do, but this would still leave a bunch of empty tables to delete and isn't great in terms of formatting etc. so I'd rather have it all in Word if possible. Also, this would mean for some jobs the list of tasks would read e.g. 1,2,3,9,10,17 etc. when I'd much prefer it to be 1,2,3,4,5 etc.
Any advice and help regarding how to approach this problem would be greatly appreciated.

Read other answers

Hi all,
I have searched for a solution to this but as yet I haven't found the right thing.
I have a work book that was made with the help of Hans on here (A sheet to track training) that automatically sends emails out and updates the sheet which is working great.
What I am now trying to do is to have the sheet auto update depending on data in another excel file.

I get sent the data each week and I would like my tracker to automatically read the other file and insert any new data, is this possible without ending up with lots of duplicated rows or incorrect data?

I will upload a sample of the tracker that was made on here with Hans later this afternoon and also a sample of the file I receive each week to see if its possible, I have been playing around with it but I cannot seem to understand how to have it read the other file and update the relevant fields.
An important part to this is the cells on the tracker would need to keep their conditional formatting and any formulas relating to the cell as if I had typed the new data in myself.

I hope it makes at least a little sense, please do let me know if clarification is needed.

Thanks for your time once again.

A:populating from one workbook in to another automatically

Read other 9 answers

I had an idea... in my company there are several stand-alone contact lists each one managed with a separated Excel file. These directory of contacts are in several cities for that I had that idea:
create a master directory excel sheet managed by the HQ and populate it with all the other "branch" files uploaded on Google Drive or any other Web space by the users.
What the VBS or macro should do is anytimes I open the master document, it must look inside the path where the files have been uploaded then one by one import in into the master doc by creating the sheets inside each one.
Which one is the way to do that?

A:How to populate an Excel doc with external Excel files.

In the branch worksheet, select the cell you want to link to and click Copy. Switch to the master spreadsheet and click the cell where you want the link. Then, right-click and select the Paste Link from the Paste menu.

Read other 6 answers


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: ModName: excel.exe
ModVer: Offset: 002aa2b3

HELP !!!


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

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?

Read other answers

I have problem, when I put link to .XPS document in MS word document, i can't open this link, nothing hapens , links to other file types works fine. XPS document opens without problem with IE when opening file from folder. I tried to lower security setings in IE hidden security zone "my computer" , but this wont help. There is no problem in Windows 7 with xps links. But i need it to work in Vista. I think it's some kind of security problems. Any ideas ?

Vindows Vista32 SP2
MS Office 2007 SP2

A:Can't open .XPS document link from word document

Will this be any help:http://www.microsoft.com/whdc/xps/viewxps.mspx

Read other 2 answers

I have a form with a subform. When I enter the Employee number in the appropriate field, the subform updates with the employee's information. I then want my form (not subform) to automatically populate in another field from the subform that has the individual employee's information. How can this be done. I have racked my brain and I know there has to be a way. OBP, are you out there?

A:Solved: Automatically populate info into field after subform updates, Access 2007, OB

Read other 16 answers

I have these two files: template(attached for reference), The Data file.

The Template – is a form I want to populate with data from the (data file) i attached it so you can see(i want macro to open the datafile filter it by distributor and list all the data for each particular distributor then copy the data and open the template file and paste the copy data on cell a6:g6 and down depend on how many data it pull for that particular datafile.

The datafile – that file has all the information/data I want to populate on the template

PS: I want to be able to run a macro where, macro would filter my data file by distributors and copy the data distributors by distributors and paste it in to the template file(after each distributor/filterdown it create a new ws for the new set of data for the next distributor). I attached some example but I didn’t send the data file OR i would like to have a macro to run every time the value change in cell "c2" it opens the data file and if c2 match value a2 in data file, i want it to copy all the data for that value in column a then copy and come paste it to template form. i attached the template and example or reference.

Your help is greatly appreciated!! plz

A:Populate excel form

Read other 6 answers

submit php form / web form / or just customize link (I have requests active on the field)
Hi all, I would really appreciate some help or direction on this. I searched web form on this forum and went 25 pages deep seeing nothing like this.

currently I have this working for me

Sub ticketsystem()
'Dim PageNumber As Object

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "wwwDOTticketsystemDOTcom/admin/new_ticketDOTphp"
Request = "?name=john&subject=testing&message=testing123123123"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState <> 4

End Sub

takes me to website with the request info populated.

I am happy to do this 2 ways, either have the VBA script login and fill out the webform.. or just have the vba script populate the URL with data from the currently selected email/open email...
like in the code above the link should contain this to pre populate the form...

(I do not need it to submit the form, web session must stay open)

URL= wwwDOTticketsystemDOTcom/admin/new_ticketDOTphp
Request = "?name=nameofsender&subject=subjectofemail&message=body%of%email"

Basically: this is stopping me from having to copy & paste ( subject / from / body ) into a basic html/php form 40 times a day, that's 3 copy & pastes and 3 alt tabs (1 monitor) I still would need to categorize it and enter time spent on the web form, so no need to comp... Read more

Read other answers

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.


Read other answers

I was working in Word 2000 and I accidentally saved one document over the top of another one so that the first document seems to be lost. I had saved the original document several times but stupidly saved something completely different under the same name. The programme assumes it is just a revision of the document so auto recovery and the recycle bin don't work. The computer hasn't been switched off so I was wondering if it is possible to somehow undo the last save I made.

Please help me if you can!

A:Retrieving a saved over document

Welcome to TSG, Ellie.

I'm sorry that it is probably bad news. You cannot unless you want to pay hundreds of dollars for potential--mind you--POTENTIAL data recovery.

However, I always like to ask:

Did you copy this anywhere else?
Did you email it to anyone and it might be in your sent items?
Did someone email it to you?
Were you at work and this was on a network drive so that you could possibly ask your network administrator to retrieve a backup copy?

Read other 2 answers

I pulled a real bonehead move. I had opened a daily report from yesterday to use as a shortcut for today's. When I was done with the changes I clicked yes to save as opposed to saving as a new document.
Is there any way to recover the document prior to the save?

A:Saved over word document.

Read other 6 answers

I found it in roaming temp file but I can't open it, gives me no indication of what program to open it. I need this file. Windows 10 / MS Word. I named it, saved often and it auto saved. It does not show the name I gave it either.

A:Windows10 ate a document I saved.

Can you select Word as the program to open it with? Have you searched other folders to see if it got accidently dragged into another folder? How about restoring it from a backup/file history?

Please see this write up and see if it helps: https://support.microsoft.com/en-ca/help/316951/how-to-recover-a-lost-word-document

Read other 1 answers


I opened a document from my email (Microsoft Exchange) that I had worked on from home. However, I started this document at work and had it saved in its own folder. When I opened the document from my email, I continued working on it and saved throughout the process. Now, I can't seem to find the new, saved version of the document anywhere. Why is this? Is there somewhere I can look to see if it's there? I checked my temp folder (Start -> Run -> %temp%), and it wasn't there. Please help!


A:Saved Document Gone Missing

Read other 8 answers

Hello, 1st post.
I have scanned a document( application form ) using a reasonably modern flat bed scanner. I have saved the document in a folder. What do I need to do in order to be able to fill in that application form and save changes for ongoing editing ?
I am using XP home edition.

A:Editing saved document


Read other 1 answers

I ghosted in a new 320G disk to replace my 160G disk and when I tried to save files in Excel, Word and Powerpoint got this or a similar message. I finally found someone at Microsoft who had some product knowledge and here is the simple answer.

Go to Start
type offline in the search window
Disable offline files

Yep, it was that simple.

Read other answers

I am usually VERY careful about stuff like this, but this one slipped past me, and I clicked "Save" before I realized what I was doing.

I created a document called "March and April" several months ago on Windows 7/Word 2007, using my flash drive. I spent 6 hours updating it at a relative's house today -- on a different computer -- using Windows 10/Word 2013. I saved it by the same name on my flash drive.

When I got home tonight, I decided to make a few more changes to it using my laptop; however, I didn't realize, initially, that my laptop still had the OLD version open and on the screen. So, when it asked me if I wanted to save March and April, it did, and overwrote all the work that was already on my flash drive.

I didn't realize I had done it until I closed the document, so Undo is not an option. I have already looked for a Previous Versions option, and it doesn't exist. I have not backed anything up. I don't have Dropbox. I've already tried Recuva. There are no shadow versions, either.
So, my question is, if I take the flash drive back over to my relative's home, open Word and then click on the "March and April" listed in Recent Documents, which version will open? The last one that was on the Windows 10 PC? Or the one that's on my flash drive? Or could I try it without the flash drive?


Read other answers

I hope I can explain this adequately. I use a website (Ancestry.com) from which you can save an image on your harddrive. I went to save and the usual window opened up which was "documents library" though basically "my documents" folder - I saved to a folder within this location. When exiting the website and going to "my documents" folder, it was not there. I realized at this time, actually, that I've had this problem before. Though the file was definitely saved, it does not show up even in a search of the entire C drive. Returning to Ancestry, this time, instead of saving to the default folder, I went to C - users - my user name. This time there was a "Documents" folder in the list. Not "My Documents" - just plain "Documents." THAT was where the previously saved file was. I still cannot find it anywhere on my harddrive with a search, nor is there any plain "Documents." folder when I try to access it outside the saving process. I read this discussion on the difference between "documents" and "my documents" and it seems as if there's not really supposed to be a difference. My experience doesn't jive with that, but I have NO idea what the answer is. If it was just an Ancestry document, it would be annoying rather than important. However, my son also lost a work-related document he thought he saved in somewhat the same situation. Can someone please explain this (in somewhat simple terms) so... Read more

A:Saved document lost

Hello Clairespin, welcome to Windows Seven Forums.

In Windows 7, the Documents feature is actually a virtual library (which is why you couldn't see it when you searched for it) where you can link to files from different locations on your computer.

For example, I have a data folder on a separate partition where I keep all my personal data. If I then right-click this folder and select Include in Library it will appear in the library I choose even though it hasn't been moved to the library.

Libraries just make it a lot easier to keep tabs on your personal files by allowing you to look in one location for them rather than several locations on your hard drive.

By default, the Documents library includes your My Documents or Documents folder and the Public Documents folder, but you can add any other folders you want.

You might like to read this Microsoft article: How to organize computer files and folders: 9 file management tips

Read other 9 answers

I have an excel 2000 file (size: 12.5MB). The file is stored on a NT file server. The server is connected on a switch (A). The client PC that tried to access the file is on a BNC cable connection that connects to a 10Mbps hub and this hub connects to another 10Mbps hub and this hub goes to the switch (A). The problem happened when the user tried to update the Excel file. He opened it from the server. He made some modifications to the data and then he pressed the saved button. Excel 2000 begun saving (file.xls) and finally the following error message appeared on screen: "DOCUMENT SAVED SUCESSFULLY. CAN NOT REOPEN THE SAVED DOCUMENT DUE TO LOW MEMORY. PLEASE CLOSE THE DOCUMENT". If I press OK button then the document will be damaged and will not be opened again, so I tried to save it again. I pressed the save option but instead of saving it, I noticed that the SAVE AS dialog box appeared. I thought that something wrong is going on. I saved the Excel file on the SERVER using another filename (file2.xls). The saving process was successful. I closed Excel 2000 and I loaded again. I tried to open the Excel file (file.xls) but the opening failed with the following error message: "FILE file.xls is not in recognizable form ". After that I tried to open the file2.xls and I SUCCEEDED IN OPENING IT WITHOUT PROBLEMS.

RAM 128MB)

Question 1: Is the problem to do with the NETWORK?
Question 2: Is the problem to do with... Read more


Day: To my knowledge this has to do with network refresh not being done often enough. But I'm not a network person, so I really have no idea!

Brainbench MVP for Microsoft Word

Read other 2 answers